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.

1 files changed, 60 insertions, 56 deletions

diff --git a/src/include/catalog/pg_opclass.h b/src/include/catalog/pg_opclass.h
index 2e25e366c6..edb29267d6 100644
--- a/src/include/catalog/pg_opclass.h
+++ b/src/include/catalog/pg_opclass.h
@@ -26,7 +26,7 @@
  * Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
- * $Id: pg_opclass.h,v 1.43 2001/11/05 17:46:32 momjian Exp $
+ * $Id: pg_opclass.h,v 1.44 2002/04/17 20:57:56 tgl Exp $
  *
  * NOTES
  *	  the genbki.sh script reads this file and generates .bki
@@ -54,6 +54,8 @@ CATALOG(pg_opclass)
 {
 	Oid			opcamid;		/* index access method opclass is for */
 	NameData	opcname;		/* name of this opclass */
+	Oid			opcnamespace;	/* namespace of this opclass */
+	int4		opcowner;		/* opclass owner */
 	Oid			opcintype;		/* type of input data for opclass */
 	bool		opcdefault;		/* T if opclass is default for opcintype */
 	Oid			opckeytype;		/* type of index data, or InvalidOid */
@@ -70,71 +72,73 @@ typedef FormData_pg_opclass *Form_pg_opclass;
  *		compiler constants for pg_opclass
  * ----------------
  */
-#define Natts_pg_opclass				5
+#define Natts_pg_opclass				7
 #define Anum_pg_opclass_opcamid			1
 #define Anum_pg_opclass_opcname			2
-#define Anum_pg_opclass_opcintype		3
-#define Anum_pg_opclass_opcdefault		4
-#define Anum_pg_opclass_opckeytype		5
+#define Anum_pg_opclass_opcnamespace	3
+#define Anum_pg_opclass_opcowner		4
+#define Anum_pg_opclass_opcintype		5
+#define Anum_pg_opclass_opcdefault		6
+#define Anum_pg_opclass_opckeytype		7
 
 /* ----------------
  *		initial contents of pg_opclass
  * ----------------
  */
 
-DATA(insert OID =  421 (	403		abstime_ops		 702	t	0 ));
-DATA(insert OID =  422 (	402		bigbox_ops		 603	f	0 ));
-DATA(insert OID =  423 (	403		bit_ops			1560	t	0 ));
-DATA(insert OID =  424 (	403		bool_ops		  16	t	0 ));
-DATA(insert OID =  425 (	402		box_ops			 603	t	0 ));
-DATA(insert OID =  426 (	403		bpchar_ops		1042	t	0 ));
-DATA(insert OID =  427 (	405		bpchar_ops		1042	t	0 ));
-DATA(insert OID =  428 (	403		bytea_ops		  17	t	0 ));
-DATA(insert OID =  429 (	403		char_ops		  18	t	0 ));
-DATA(insert OID =  431 (	405		char_ops		  18	t	0 ));
-DATA(insert OID =  432 (	403		cidr_ops		 650	t	0 ));
-DATA(insert OID =  433 (	405		cidr_ops		 650	t	0 ));
-DATA(insert OID =  434 (	403		date_ops		1082	t	0 ));
-DATA(insert OID =  435 (	405		date_ops		1082	t	0 ));
-DATA(insert OID = 1970 (	403		float4_ops		 700	t	0 ));
-DATA(insert OID = 1971 (	405		float4_ops		 700	t	0 ));
-DATA(insert OID = 1972 (	403		float8_ops		 701	t	0 ));
-DATA(insert OID = 1973 (	405		float8_ops		 701	t	0 ));
-DATA(insert OID = 1974 (	403		inet_ops		 869	t	0 ));
-DATA(insert OID = 1975 (	405		inet_ops		 869	t	0 ));
-DATA(insert OID = 1976 (	403		int2_ops		  21	t	0 ));
+DATA(insert OID =  421 (	403		abstime_ops		PGNSP PGUID  702 t 0 ));
+DATA(insert OID =  422 (	402		bigbox_ops		PGNSP PGUID  603 f 0 ));
+DATA(insert OID =  423 (	403		bit_ops			PGNSP PGUID 1560 t 0 ));
+DATA(insert OID =  424 (	403		bool_ops		PGNSP PGUID   16 t 0 ));
+DATA(insert OID =  425 (	402		box_ops			PGNSP PGUID  603 t 0 ));
+DATA(insert OID =  426 (	403		bpchar_ops		PGNSP PGUID 1042 t 0 ));
+DATA(insert OID =  427 (	405		bpchar_ops		PGNSP PGUID 1042 t 0 ));
+DATA(insert OID =  428 (	403		bytea_ops		PGNSP PGUID   17 t 0 ));
+DATA(insert OID =  429 (	403		char_ops		PGNSP PGUID   18 t 0 ));
+DATA(insert OID =  431 (	405		char_ops		PGNSP PGUID   18 t 0 ));
+DATA(insert OID =  432 (	403		cidr_ops		PGNSP PGUID  650 t 0 ));
+DATA(insert OID =  433 (	405		cidr_ops		PGNSP PGUID  650 t 0 ));
+DATA(insert OID =  434 (	403		date_ops		PGNSP PGUID 1082 t 0 ));
+DATA(insert OID =  435 (	405		date_ops		PGNSP PGUID 1082 t 0 ));
+DATA(insert OID = 1970 (	403		float4_ops		PGNSP PGUID  700 t 0 ));
+DATA(insert OID = 1971 (	405		float4_ops		PGNSP PGUID  700 t 0 ));
+DATA(insert OID = 1972 (	403		float8_ops		PGNSP PGUID  701 t 0 ));
+DATA(insert OID = 1973 (	405		float8_ops		PGNSP PGUID  701 t 0 ));
+DATA(insert OID = 1974 (	403		inet_ops		PGNSP PGUID  869 t 0 ));
+DATA(insert OID = 1975 (	405		inet_ops		PGNSP PGUID  869 t 0 ));
+DATA(insert OID = 1976 (	403		int2_ops		PGNSP PGUID   21 t 0 ));
 #define INT2_BTREE_OPS_OID 1976
-DATA(insert OID = 1977 (	405		int2_ops		  21	t	0 ));
-DATA(insert OID = 1978 (	403		int4_ops		  23	t	0 ));
+DATA(insert OID = 1977 (	405		int2_ops		PGNSP PGUID   21 t 0 ));
+DATA(insert OID = 1978 (	403		int4_ops		PGNSP PGUID   23 t 0 ));
 #define INT4_BTREE_OPS_OID 1978
-DATA(insert OID = 1979 (	405		int4_ops		  23	t	0 ));
-DATA(insert OID = 1980 (	403		int8_ops		  20	t	0 ));
-DATA(insert OID = 1981 (	405		int8_ops		  20	t	0 ));
-DATA(insert OID = 1982 (	403		interval_ops	1186	t	0 ));
-DATA(insert OID = 1983 (	405		interval_ops	1186	t	0 ));
-DATA(insert OID = 1984 (	403		macaddr_ops		 829	t	0 ));
-DATA(insert OID = 1985 (	405		macaddr_ops		 829	t	0 ));
-DATA(insert OID = 1986 (	403		name_ops		  19	t	0 ));
-DATA(insert OID = 1987 (	405		name_ops		  19	t	0 ));
-DATA(insert OID = 1988 (	403		numeric_ops		1700	t	0 ));
-DATA(insert OID = 1989 (	403		oid_ops			  26	t	0 ));
+DATA(insert OID = 1979 (	405		int4_ops		PGNSP PGUID   23 t 0 ));
+DATA(insert OID = 1980 (	403		int8_ops		PGNSP PGUID   20 t 0 ));
+DATA(insert OID = 1981 (	405		int8_ops		PGNSP PGUID   20 t 0 ));
+DATA(insert OID = 1982 (	403		interval_ops	PGNSP PGUID 1186 t 0 ));
+DATA(insert OID = 1983 (	405		interval_ops	PGNSP PGUID 1186 t 0 ));
+DATA(insert OID = 1984 (	403		macaddr_ops		PGNSP PGUID  829 t 0 ));
+DATA(insert OID = 1985 (	405		macaddr_ops		PGNSP PGUID  829 t 0 ));
+DATA(insert OID = 1986 (	403		name_ops		PGNSP PGUID   19 t 0 ));
+DATA(insert OID = 1987 (	405		name_ops		PGNSP PGUID   19 t 0 ));
+DATA(insert OID = 1988 (	403		numeric_ops		PGNSP PGUID 1700 t 0 ));
+DATA(insert OID = 1989 (	403		oid_ops			PGNSP PGUID   26 t 0 ));
 #define OID_BTREE_OPS_OID 1989
-DATA(insert OID = 1990 (	405		oid_ops			  26	t	0 ));
-DATA(insert OID = 1991 (	403		oidvector_ops	  30	t	0 ));
-DATA(insert OID = 1992 (	405		oidvector_ops	  30	t	0 ));
-DATA(insert OID = 1993 (	402		poly_ops		 604	t	0 ));
-DATA(insert OID = 1994 (	403		text_ops		  25	t	0 ));
-DATA(insert OID = 1995 (	405		text_ops		  25	t	0 ));
-DATA(insert OID = 1996 (	403		time_ops		1083	t	0 ));
-DATA(insert OID = 1997 (	405		time_ops		1083	t	0 ));
-DATA(insert OID = 1998 (	403		timestamptz_ops 1184	t	0 ));
-DATA(insert OID = 1999 (	405		timestamptz_ops 1184	t	0 ));
-DATA(insert OID = 2000 (	403		timetz_ops		1266	t	0 ));
-DATA(insert OID = 2001 (	405		timetz_ops		1266	t	0 ));
-DATA(insert OID = 2002 (	403		varbit_ops		1562	t	0 ));
-DATA(insert OID = 2003 (	403		varchar_ops		1043	t	0 ));
-DATA(insert OID = 2004 (	405		varchar_ops		1043	t	0 ));
-DATA(insert OID = 2039 (	403		timestamp_ops	1114	t	0 ));
-DATA(insert OID = 2040 (	405		timestamp_ops	1114	t	0 ));
+DATA(insert OID = 1990 (	405		oid_ops			PGNSP PGUID   26 t 0 ));
+DATA(insert OID = 1991 (	403		oidvector_ops	PGNSP PGUID   30 t 0 ));
+DATA(insert OID = 1992 (	405		oidvector_ops	PGNSP PGUID   30 t 0 ));
+DATA(insert OID = 1993 (	402		poly_ops		PGNSP PGUID  604 t 0 ));
+DATA(insert OID = 1994 (	403		text_ops		PGNSP PGUID   25 t 0 ));
+DATA(insert OID = 1995 (	405		text_ops		PGNSP PGUID   25 t 0 ));
+DATA(insert OID = 1996 (	403		time_ops		PGNSP PGUID 1083 t 0 ));
+DATA(insert OID = 1997 (	405		time_ops		PGNSP PGUID 1083 t 0 ));
+DATA(insert OID = 1998 (	403		timestamptz_ops	PGNSP PGUID 1184 t 0 ));
+DATA(insert OID = 1999 (	405		timestamptz_ops	PGNSP PGUID 1184 t 0 ));
+DATA(insert OID = 2000 (	403		timetz_ops		PGNSP PGUID 1266 t 0 ));
+DATA(insert OID = 2001 (	405		timetz_ops		PGNSP PGUID 1266 t 0 ));
+DATA(insert OID = 2002 (	403		varbit_ops		PGNSP PGUID 1562 t 0 ));
+DATA(insert OID = 2003 (	403		varchar_ops		PGNSP PGUID 1043 t 0 ));
+DATA(insert OID = 2004 (	405		varchar_ops		PGNSP PGUID 1043 t 0 ));
+DATA(insert OID = 2039 (	403		timestamp_ops	PGNSP PGUID 1114 t 0 ));
+DATA(insert OID = 2040 (	405		timestamp_ops	PGNSP PGUID 1114 t 0 ));
 
 #endif   /* PG_OPCLASS_H */