From 27a54ae282d74ee471a5b34d136fe3d4f894a9de Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Wed, 17 Apr 2002 20:57:57 +0000
Subject: Opclasses live in namespaces.  I also took the opportunity to create
 an 'opclass owner' column in pg_opclass.  Nothing is done with it at present,
 but since there are plans to invent a CREATE OPERATOR CLASS command soon,
 we'll probably want DROP OPERATOR CLASS too, which suggests that a notion of
 ownership would be a good idea.

---
 doc/src/sgml/xindex.sgml | 12 +++++++-----
 1 file changed, 7 insertions(+), 5 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/xindex.sgml b/doc/src/sgml/xindex.sgml
index 6a906291411..dcb5f9b6517 100644
--- a/doc/src/sgml/xindex.sgml
+++ b/doc/src/sgml/xindex.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/xindex.sgml,v 1.23 2002/03/27 19:19:23 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/xindex.sgml,v 1.24 2002/04/17 20:57:56 tgl Exp $
 PostgreSQL documentation
 -->
 
@@ -280,10 +280,12 @@ SELECT oid FROM pg_am WHERE amname = 'btree';
    <classname>pg_opclass</classname>:
 
 <programlisting>
-INSERT INTO pg_opclass (opcamid, opcname, opcintype, opcdefault, opckeytype)
+INSERT INTO pg_opclass (opcamid, opcname, opcnamespace, opcowner, opcintype, opcdefault, opckeytype)
     VALUES (
         (SELECT oid FROM pg_am WHERE amname = 'btree'),
         'complex_abs_ops',
+        (SELECT oid FROM pg_namespace WHERE nspname = 'pg_catalog'),
+        1,	-- UID of superuser is hardwired to 1 as of PG 7.3
         (SELECT oid FROM pg_type WHERE typname = 'complex'),
         true,
         0);
@@ -292,9 +294,9 @@ SELECT oid, *
     FROM pg_opclass
     WHERE opcname = 'complex_abs_ops';
 
-  oid   | opcamid |     opcname     | opcintype | opcdefault | opckeytype
---------+---------+-----------------+-----------+------------+------------
- 277975 |     403 | complex_abs_ops |    277946 | t          |          0
+  oid   | opcamid |     opcname     | opcnamespace | opcowner | opcintype | opcdefault | opckeytype
+--------+---------+-----------------+--------------+----------+-----------+------------+------------
+ 277975 |     403 | complex_abs_ops |           11 |        1 |    277946 | t          |          0
 (1 row)
 </programlisting>
 
-- 
cgit v1.2.3