From 861ea4ba53b3f05f43b1aa3dfc14bd2353c8fabb Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 25 Jun 2003 01:14:37 +0000 Subject: [PATCH] Create entries for the foreign keys in the system catalog chapter. I got tired of hitting the 'up' link, then finding the table in the table of contents, and following it back down. Rod Taylor --- doc/src/sgml/catalogs.sgml | 188 ++++++++++++++++++------------------- 1 file changed, 94 insertions(+), 94 deletions(-) diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 835739d81b..777bdd9291 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,6 +1,6 @@ @@ -230,25 +230,25 @@ aggfnoid regproc - pg_proc.oid + pg_proc.oid pg_proc OID of the aggregate function aggtransfn regproc - pg_proc.oid + pg_proc.oid Transition function aggfinalfn regproc - pg_proc.oid + pg_proc.oid Final function (zero if none) aggtranstype oid - pg_type.oid + pg_type.oid The type of the aggregate function's internal transition (state) data @@ -313,7 +313,7 @@ amowner int4 - pg_shadow.usesysid + pg_shadow.usesysid User ID of the owner (currently not used) @@ -370,77 +370,77 @@ amgettuple regproc - pg_proc.oid + pg_proc.oid Next valid tuple function aminsert regproc - pg_proc.oid + pg_proc.oid Insert this tuple function ambeginscan regproc - pg_proc.oid + pg_proc.oid Start new scan function amrescan regproc - pg_proc.oid + pg_proc.oid Restart this scan function amendscan regproc - pg_proc.oid + pg_proc.oid End this scan function ammarkpos regproc - pg_proc.oid + pg_proc.oid Mark current scan position function amrestrpos regproc - pg_proc.oid + pg_proc.oid Restore marked scan position function ambuild regproc - pg_proc.oid + pg_proc.oid Build new index function ambulkdelete regproc - pg_proc.oid + pg_proc.oid Bulk-delete function amvacuumcleanup regproc - pg_proc.oid + pg_proc.oid Post-VACUUM cleanup function amcostestimate regproc - pg_proc.oid + pg_proc.oid Function to estimate cost of an index scan @@ -495,7 +495,7 @@ amopclaid oid - pg_opclass.oid + pg_opclass.oid The index operator class this entry is for @@ -516,7 +516,7 @@ amopopr oid - pg_operator.oid + pg_operator.oid OID of the operator @@ -558,7 +558,7 @@ amopclaid oid - pg_opclass.oid + pg_opclass.oid The index operator class this entry is for @@ -572,7 +572,7 @@ amproc regproc - pg_proc.oid + pg_proc.oid OID of the procedure @@ -615,7 +615,7 @@ adrelid oid - pg_class.oid + pg_class.oid The table this column belongs to @@ -683,7 +683,7 @@ attrelid oid - pg_class.oid + pg_class.oid The table this column belongs to @@ -697,7 +697,7 @@ atttypid oid - pg_type.oid + pg_type.oid The data type of this column @@ -908,21 +908,21 @@ castsource oid - pg_type.oid + pg_type.oid OID of the source data type casttarget oid - pg_type.oid + pg_type.oid OID of the target data type castfunc oid - pg_proc.oid + pg_proc.oid The OID of the function to use to perform this cast. Zero is stored if the data types are binary compatible (that is, no @@ -991,7 +991,7 @@ relnamespace oid - pg_namespace.oid + pg_namespace.oid The OID of the namespace that contains this relation @@ -1000,7 +1000,7 @@ reltype oid - pg_type.oid + pg_type.oid The OID of the data type that corresponds to this table, if any (zero for indexes, which have no pg_type entry) @@ -1010,14 +1010,14 @@ relowner int4 - pg_shadow.usesysid + pg_shadow.usesysid Owner of the relation relam oid - pg_am.oid + pg_am.oid If this is an index, the access method used (B-tree, hash, etc.) @@ -1056,7 +1056,7 @@ reltoastrelid oid - pg_class.oid + pg_class.oid OID of the TOAST table associated with this table, 0 if none. The TOAST table stores large attributes out of @@ -1067,7 +1067,7 @@ reltoastidxid oid - pg_class.oid + pg_class.oid For a TOAST table, the OID of its index. 0 if not a TOAST table. @@ -1252,7 +1252,7 @@ connamespace oid - pg_namespace.oid + pg_namespace.oid The OID of the namespace that contains this constraint @@ -1287,21 +1287,21 @@ conrelid oid - pg_class.oid + pg_class.oid The table this constraint is on; 0 if not a table constraint contypid oid - pg_type.oid + pg_type.oid The domain this constraint is on; 0 if not a domain constraint confrelid oid - pg_class.oid + pg_class.oid If a foreign key, the referenced table; else 0 @@ -1329,14 +1329,14 @@ conkey int2[] - pg_attribute.attnum + pg_attribute.attnum If a table constraint, list of columns which the constraint constrains confkey int2[] - pg_attribute.attnum + pg_attribute.attnum If a foreign key, list of the referenced columns @@ -1403,7 +1403,7 @@ connamespace oid - pg_namespace.oid + pg_namespace.oid The OID of the namespace that contains this conversion @@ -1412,7 +1412,7 @@ conowner int4 - pg_shadow.usesysid + pg_shadow.usesysid Owner of the conversion @@ -1433,7 +1433,7 @@ conproc regproc - pg_proc.oid + pg_proc.oid Conversion procedure @@ -1496,7 +1496,7 @@ datdba int4 - pg_shadow.usesysid + pg_shadow.usesysid Owner of the database, usually the user who created it @@ -1624,7 +1624,7 @@ classid oid - pg_class.oid + pg_class.oid The OID of the system catalog the dependent object is in @@ -1800,7 +1800,7 @@ classoid oid - pg_class.oid + pg_class.oid The OID of the system catalog this object appears in @@ -1882,7 +1882,7 @@ grolist int4[] - pg_shadow.usesysid + pg_shadow.usesysid An array containing the IDs of the users in this group @@ -1922,21 +1922,21 @@ indexrelid oid - pg_class.oid + pg_class.oid The OID of the pg_class entry for this index indrelid oid - pg_class.oid + pg_class.oid The OID of the pg_class entry for the table this index is for indkey int2vector - pg_attribute.attnum + pg_attribute.attnum This is an array of indnatts (up to INDEX_MAX_KEYS) values that indicate which @@ -1951,7 +1951,7 @@ indclass oidvector - pg_opclass.oid + pg_opclass.oid For each column in the index key this contains the OID of the operator class to use. See @@ -2042,7 +2042,7 @@ inhrelid oid - pg_class.oid + pg_class.oid The OID of the child table. @@ -2051,7 +2051,7 @@ inhparent oid - pg_class.oid + pg_class.oid The OID of the parent table. @@ -2137,7 +2137,7 @@ lanplcallfoid oid - pg_proc.oid + pg_proc.oid For noninternal languages this references the language handler, which is a special function that is responsible for @@ -2149,7 +2149,7 @@ lanvalidator oid - pg_proc.oid + pg_proc.oid This references a language validator function that is responsible for checking the syntax and validity of new functions when they @@ -2343,7 +2343,7 @@ nspowner int4 - pg_shadow.usesysid + pg_shadow.usesysid Owner of the namespace @@ -2397,7 +2397,7 @@ opcamid oid - pg_am.oid + pg_am.oid Index access method opclass is for @@ -2411,21 +2411,21 @@ opcnamespace oid - pg_namespace.oid + pg_namespace.oid Namespace of this operator class opcowner int4 - pg_shadow.usesysid + pg_shadow.usesysid Operator class owner opcintype oid - pg_type.oid + pg_type.oid Input data type of the operator class @@ -2439,7 +2439,7 @@ opckeytype oid - pg_type.oid + pg_type.oid Type of index data, or zero if same as opcintype @@ -2498,7 +2498,7 @@ oprnamespace oid - pg_namespace.oid + pg_namespace.oid The OID of the namespace that contains this operator @@ -2507,7 +2507,7 @@ oprowner int4 - pg_shadow.usesysid + pg_shadow.usesysid Owner of the operator @@ -2531,42 +2531,42 @@ oprleft oid - pg_type.oid + pg_type.oid Type of the left operand oprright oid - pg_type.oid + pg_type.oid Type of the right operand oprresult oid - pg_type.oid + pg_type.oid Type of the result oprcom oid - pg_operator.oid + pg_operator.oid Commutator of this operator, if any oprnegate oid - pg_operator.oid + pg_operator.oid Negator of this operator, if any oprlsortop oid - pg_operator.oid + pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L) @@ -2576,7 +2576,7 @@ oprrsortop oid - pg_operator.oid + pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R) @@ -2586,7 +2586,7 @@ oprltcmpop oid - pg_operator.oid + pg_operator.oid If this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R) @@ -2596,7 +2596,7 @@ oprgtcmpop oid - pg_operator.oid + pg_operator.oid If this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R) @@ -2606,21 +2606,21 @@ oprcode regproc - pg_proc.oid + pg_proc.oid Function that implements this operator oprrest regproc - pg_proc.oid + pg_proc.oid Restriction selectivity estimation function for this operator oprjoin regproc - pg_proc.oid + pg_proc.oid Join selectivity estimation function for this operator @@ -2679,7 +2679,7 @@ pronamespace oid - pg_namespace.oid + pg_namespace.oid The OID of the namespace that contains this function @@ -2688,14 +2688,14 @@ proowner int4 - pg_shadow.usesysid + pg_shadow.usesysid Owner of the function prolang oid - pg_language.oid + pg_langauge.oid Implementation language or call interface of this function @@ -2763,14 +2763,14 @@ prorettype oid - pg_type.oid + pg_type.oid Data type of the return value proargtypes oidvector - pg_type.oid + pg_type.oid An array with the data types of the function arguments @@ -2852,7 +2852,7 @@ ev_class oid - pg_class.oid + pg_class.oid The table this rule is for @@ -3083,14 +3083,14 @@ starelid oid - pg_class.oid + pg_class.oid The table that the described column belongs to staattnum int2 - pg_attribute.attnum + pg_attribute.attnum The number of the described column @@ -3135,7 +3135,7 @@ staopN oid - pg_operator.oid + pg_operator.oid An operator used to derive the statistics stored in the Nth slot. For example, a @@ -3204,7 +3204,7 @@ tgrelid oid - pg_class.oid + pg_class.oid The table this trigger is on @@ -3218,7 +3218,7 @@ tgfoid oid - pg_proc.oid + pg_proc.oid The function to be called @@ -3255,7 +3255,7 @@ tgconstrrelid oid - pg_class.oid + pg_class.oid The table referenced by an referential integrity constraint @@ -3347,7 +3347,7 @@ typnamespace oid - pg_namespace.oid + pg_namespace.oid The OID of the namespace that contains this type @@ -3356,7 +3356,7 @@ typowner int4 - pg_shadow.usesysid + pg_shadow.usesysid Owner of the type @@ -3428,7 +3428,7 @@ typrelid oid - pg_class.oid + pg_class.oid If this is a composite type (see typtype), then this column points to @@ -3444,7 +3444,7 @@ typelem oid - pg_type.oid + pg_type.oid If typelem is not 0 then it identifies another row in pg_type. @@ -3466,28 +3466,28 @@ typinput regproc - pg_proc.oid + pg_proc.oid Input conversion function (text format) typoutput regproc - pg_proc.oid + pg_proc.oid Output conversion function (text format) typreceive regproc - pg_proc.oid + pg_proc.oid Input conversion function (binary format), or 0 if none typsend regproc - pg_proc.oid + pg_proc.oid Output conversion function (binary format), or 0 if none -- 2.40.0