Add unique index on pg_cast.oid, and document pg_cast table.

[postgresql] / src / include / catalog / indexing.h

diff --git a/src/include/catalog/indexing.h b/src/include/catalog/indexing.h
index 777a4031dd79b14f52682588642b1eb6684c379d..db14ae6bd6829ac7f2ac4945b73d48b5b8d2bcc4 100644 (file)
--- a/src/include/catalog/indexing.h
+++ b/src/include/catalog/indexing.h
@@ -8,7 +8,7 @@
  * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
- * $Id: indexing.h,v 1.71 2002/07/18 23:11:30 petere Exp $
+ * $Id: indexing.h,v 1.72 2002/07/22 20:23:19 petere Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -26,7 +26,7 @@
 #define Num_pg_amproc_indices          1
 #define Num_pg_attr_indices                    2
 #define Num_pg_attrdef_indices         2
-#define Num_pg_cast_indices                    1
+#define Num_pg_cast_indices                    2
 #define Num_pg_class_indices           2
 #define Num_pg_constraint_indices      3
 #define Num_pg_conversion_indices      3
@@ -61,6 +61,7 @@
 #define AttrDefaultOidIndex                    "pg_attrdef_oid_index"
 #define AttributeRelidNameIndex                "pg_attribute_relid_attnam_index"
 #define AttributeRelidNumIndex         "pg_attribute_relid_attnum_index"
+#define CastOidIndex                           "pg_cast_oid_index"
 #define CastSourceTargetIndex          "pg_cast_source_target_index"
 #define ClassNameNspIndex                      "pg_class_relname_nsp_index"
 #define ClassOidIndex                          "pg_class_oid_index"
@@ -169,6 +170,7 @@ DECLARE_UNIQUE_INDEX(pg_attrdef_adrelid_adnum_index on pg_attrdef using btree(ad
 DECLARE_UNIQUE_INDEX(pg_attrdef_oid_index on pg_attrdef using btree(oid oid_ops));
 DECLARE_UNIQUE_INDEX(pg_attribute_relid_attnam_index on pg_attribute using btree(attrelid oid_ops, attname name_ops));
 DECLARE_UNIQUE_INDEX(pg_attribute_relid_attnum_index on pg_attribute using btree(attrelid oid_ops, attnum int2_ops));
+DECLARE_UNIQUE_INDEX(pg_cast_oid_index on pg_cast using btree(oid oid_ops));
 DECLARE_UNIQUE_INDEX(pg_cast_source_target_index on pg_cast using btree(castsource oid_ops, casttarget oid_ops));
 DECLARE_UNIQUE_INDEX(pg_class_oid_index on pg_class using btree(oid oid_ops));
 DECLARE_UNIQUE_INDEX(pg_class_relname_nsp_index on pg_class using btree(relname name_ops, relnamespace oid_ops));