diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2002-07-22 20:23:19 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2002-07-22 20:23:19 +0000 |
| commit | e9c013f4bddd953df03be74177a37016d1e22b96 (patch) | |
| tree | 8aa2299d3c1666eb5647c60e805aad0b6924cd9a /src/include/catalog/indexing.h | |
| parent | a7ffd69d4cc38ea9ede168719caba354b3af0a99 (diff) | |
| download | postgresql-e9c013f4bddd953df03be74177a37016d1e22b96.tar.gz | |
Add unique index on pg_cast.oid, and document pg_cast table.
Diffstat (limited to 'src/include/catalog/indexing.h')
| -rw-r--r-- | src/include/catalog/indexing.h | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/include/catalog/indexing.h b/src/include/catalog/indexing.h index 777a4031dd..db14ae6bd6 100644 --- 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)); |