Index: doc/src/sgml/catalogs.sgml =================================================================== RCS file: /home/rbt/work/postgresql/cvs/pgsql-server/doc/src/sgml/catalogs.sgml,v retrieving revision 2.71 diff -c -r2.71 catalogs.sgml *** doc/src/sgml/catalogs.sgml 28 May 2003 16:03:55 -0000 2.71 --- doc/src/sgml/catalogs.sgml 18 Jun 2003 20:13:17 -0000 *************** *** 230,254 **** aggfnoid regproc ! pg_proc.oid pg_proc OID of the aggregate function aggtransfn regproc ! pg_proc.oid Transition function aggfinalfn regproc ! pg_proc.oid Final function (zero if none) aggtranstype oid ! pg_type.oid The type of the aggregate function's internal transition (state) data --- 230,254 ---- aggfnoid regproc ! pg_proc.oid pg_proc OID of the aggregate function aggtransfn regproc ! pg_proc.oid Transition function aggfinalfn regproc ! pg_proc.oid Final function (zero if none) aggtranstype oid ! pg_type.oid The type of the aggregate function's internal transition (state) data *************** *** 313,319 **** amowner int4 ! pg_shadow.usesysid User ID of the owner (currently not used) --- 313,319 ---- amowner int4 ! pg_shadow.usesysid User ID of the owner (currently not used) *************** *** 370,446 **** amgettuple regproc ! pg_proc.oid Next valid tuple function aminsert regproc ! pg_proc.oid Insert this tuple function ambeginscan regproc ! pg_proc.oid Start new scan function amrescan regproc ! pg_proc.oid Restart this scan function amendscan regproc ! pg_proc.oid End this scan function ammarkpos regproc ! pg_proc.oid Mark current scan position function amrestrpos regproc ! pg_proc.oid Restore marked scan position function ambuild regproc ! pg_proc.oid Build new index function ambulkdelete regproc ! pg_proc.oid Bulk-delete function amvacuumcleanup regproc ! pg_proc.oid Post-VACUUM cleanup function amcostestimate regproc ! pg_proc.oid Function to estimate cost of an index scan --- 370,446 ---- amgettuple regproc ! pg_proc.oid Next valid tuple function aminsert regproc ! pg_proc.oid Insert this tuple function ambeginscan regproc ! pg_proc.oid Start new scan function amrescan regproc ! pg_proc.oid Restart this scan function amendscan regproc ! pg_proc.oid End this scan function ammarkpos regproc ! pg_proc.oid Mark current scan position function amrestrpos regproc ! pg_proc.oid Restore marked scan position function ambuild regproc ! pg_proc.oid Build new index function ambulkdelete regproc ! pg_proc.oid Bulk-delete function amvacuumcleanup regproc ! pg_proc.oid Post-VACUUM cleanup function amcostestimate regproc ! pg_proc.oid Function to estimate cost of an index scan *************** *** 495,501 **** amopclaid oid ! pg_opclass.oid The index operator class this entry is for --- 495,501 ---- amopclaid oid ! pg_opclass.oid The index operator class this entry is for *************** *** 516,522 **** amopopr oid ! pg_operator.oid OID of the operator --- 516,522 ---- amopopr oid ! pg_operator.oid OID of the operator *************** *** 558,564 **** amopclaid oid ! pg_opclass.oid The index operator class this entry is for --- 558,564 ---- amopclaid oid ! pg_opclass.oid The index operator class this entry is for *************** *** 572,578 **** amproc regproc ! pg_proc.oid OID of the procedure --- 572,578 ---- amproc regproc ! pg_proc.oid OID of the procedure *************** *** 615,621 **** adrelid oid ! pg_class.oid The table this column belongs to --- 615,621 ---- adrelid oid ! pg_class.oid The table this column belongs to *************** *** 683,689 **** attrelid oid ! pg_class.oid The table this column belongs to --- 683,689 ---- attrelid oid ! pg_class.oid The table this column belongs to *************** *** 697,703 **** atttypid oid ! pg_type.oid The data type of this column --- 697,703 ---- atttypid oid ! pg_type.oid The data type of this column *************** *** 908,928 **** castsource oid ! pg_type.oid OID of the source data type casttarget oid ! pg_type.oid OID of the target data type castfunc 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 --- 908,928 ---- castsource oid ! pg_type.oid OID of the source data type casttarget oid ! pg_type.oid OID of the target data type castfunc 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,997 **** relnamespace oid ! pg_namespace.oid The OID of the namespace that contains this relation --- 991,997 ---- relnamespace oid ! pg_namespace.oid The OID of the namespace that contains this relation *************** *** 1000,1006 **** reltype 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) --- 1000,1006 ---- reltype 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,1023 **** relowner int4 ! pg_shadow.usesysid Owner of the relation relam oid ! pg_am.oid If this is an index, the access method used (B-tree, hash, etc.) --- 1010,1023 ---- relowner int4 ! pg_shadow.usesysid Owner of the relation relam oid ! pg_am.oid If this is an index, the access method used (B-tree, hash, etc.) *************** *** 1056,1062 **** reltoastrelid oid ! pg_class.oid OID of the TOAST table associated with this table, 0 if none. The TOAST table stores large attributes out of --- 1056,1062 ---- reltoastrelid 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,1073 **** reltoastidxid oid ! pg_class.oid For a TOAST table, the OID of its index. 0 if not a TOAST table. --- 1067,1073 ---- reltoastidxid oid ! pg_class.oid For a TOAST table, the OID of its index. 0 if not a TOAST table. *************** *** 1252,1258 **** connamespace oid ! pg_namespace.oid The OID of the namespace that contains this constraint --- 1252,1258 ---- connamespace oid ! pg_namespace.oid The OID of the namespace that contains this constraint *************** *** 1287,1307 **** conrelid oid ! pg_class.oid The table this constraint is on; 0 if not a table constraint contypid oid ! pg_type.oid The domain this constraint is on; 0 if not a domain constraint confrelid oid ! pg_class.oid If a foreign key, the referenced table; else 0 --- 1287,1307 ---- conrelid oid ! pg_class.oid The table this constraint is on; 0 if not a table constraint contypid oid ! pg_type.oid The domain this constraint is on; 0 if not a domain constraint confrelid oid ! pg_class.oid If a foreign key, the referenced table; else 0 *************** *** 1329,1342 **** conkey int2[] ! pg_attribute.attnum If a table constraint, list of columns which the constraint constrains confkey int2[] ! pg_attribute.attnum If a foreign key, list of the referenced columns --- 1329,1342 ---- conkey int2[] ! pg_attribute.attnum If a table constraint, list of columns which the constraint constrains confkey int2[] ! pg_attribute.attnum If a foreign key, list of the referenced columns *************** *** 1403,1409 **** connamespace oid ! pg_namespace.oid The OID of the namespace that contains this conversion --- 1403,1409 ---- connamespace oid ! pg_namespace.oid The OID of the namespace that contains this conversion *************** *** 1412,1418 **** conowner int4 ! pg_shadow.usesysid Owner of the conversion --- 1412,1418 ---- conowner int4 ! pg_shadow.usesysid Owner of the conversion *************** *** 1433,1439 **** conproc regproc ! pg_proc.oid Conversion procedure --- 1433,1439 ---- conproc regproc ! pg_proc.oid Conversion procedure *************** *** 1496,1502 **** datdba int4 ! pg_shadow.usesysid Owner of the database, usually the user who created it --- 1496,1502 ---- datdba int4 ! pg_shadow.usesysid Owner of the database, usually the user who created it *************** *** 1624,1630 **** classid oid ! pg_class.oid The OID of the system catalog the dependent object is in --- 1624,1630 ---- classid oid ! pg_class.oid The OID of the system catalog the dependent object is in *************** *** 1800,1806 **** classoid oid ! pg_class.oid The OID of the system catalog this object appears in --- 1800,1806 ---- classoid oid ! pg_class.oid The OID of the system catalog this object appears in *************** *** 1882,1888 **** grolist int4[] ! pg_shadow.usesysid An array containing the IDs of the users in this group --- 1882,1888 ---- grolist int4[] ! pg_shadow.usesysid An array containing the IDs of the users in this group *************** *** 1922,1942 **** indexrelid oid ! pg_class.oid The OID of the pg_class entry for this index indrelid oid ! pg_class.oid The OID of the pg_class entry for the table this index is for indkey int2vector ! pg_attribute.attnum This is an array of indnatts (up to INDEX_MAX_KEYS) values that indicate which --- 1922,1942 ---- indexrelid oid ! pg_class.oid The OID of the pg_class entry for this index indrelid oid ! pg_class.oid The OID of the pg_class entry for the table this index is for indkey int2vector ! pg_attribute.attnum This is an array of indnatts (up to INDEX_MAX_KEYS) values that indicate which *************** *** 1951,1957 **** indclass oidvector ! pg_opclass.oid For each column in the index key this contains the OID of the operator class to use. See --- 1951,1957 ---- indclass oidvector ! pg_opclass.oid For each column in the index key this contains the OID of the operator class to use. See *************** *** 2042,2048 **** inhrelid oid ! pg_class.oid The OID of the child table. --- 2042,2048 ---- inhrelid oid ! pg_class.oid The OID of the child table. *************** *** 2051,2057 **** inhparent oid ! pg_class.oid The OID of the parent table. --- 2051,2057 ---- inhparent oid ! pg_class.oid The OID of the parent table. *************** *** 2137,2143 **** lanplcallfoid oid ! pg_proc.oid For noninternal languages this references the language handler, which is a special function that is responsible for --- 2137,2143 ---- lanplcallfoid oid ! pg_proc.oid For noninternal languages this references the language handler, which is a special function that is responsible for *************** *** 2149,2155 **** lanvalidator oid ! pg_proc.oid This references a language validator function that is responsible for checking the syntax and validity of new functions when they --- 2149,2155 ---- lanvalidator 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,2349 **** nspowner int4 ! pg_shadow.usesysid Owner of the namespace --- 2343,2349 ---- nspowner int4 ! pg_shadow.usesysid Owner of the namespace *************** *** 2397,2403 **** opcamid oid ! pg_am.oid Index access method opclass is for --- 2397,2403 ---- opcamid oid ! pg_am.oid Index access method opclass is for *************** *** 2411,2431 **** opcnamespace oid ! pg_namespace.oid Namespace of this operator class opcowner int4 ! pg_shadow.usesysid Operator class owner opcintype oid ! pg_type.oid Input data type of the operator class --- 2411,2431 ---- opcnamespace oid ! pg_namespace.oid Namespace of this operator class opcowner int4 ! pg_shadow.usesysid Operator class owner opcintype oid ! pg_type.oid Input data type of the operator class *************** *** 2439,2445 **** opckeytype oid ! pg_type.oid Type of index data, or zero if same as opcintype --- 2439,2445 ---- opckeytype oid ! pg_type.oid Type of index data, or zero if same as opcintype *************** *** 2498,2504 **** oprnamespace oid ! pg_namespace.oid The OID of the namespace that contains this operator --- 2498,2504 ---- oprnamespace oid ! pg_namespace.oid The OID of the namespace that contains this operator *************** *** 2507,2513 **** oprowner int4 ! pg_shadow.usesysid Owner of the operator --- 2507,2513 ---- oprowner int4 ! pg_shadow.usesysid Owner of the operator *************** *** 2531,2572 **** oprleft oid ! pg_type.oid Type of the left operand oprright oid ! pg_type.oid Type of the right operand oprresult oid ! pg_type.oid Type of the result oprcom oid ! pg_operator.oid Commutator of this operator, if any oprnegate oid ! pg_operator.oid Negator of this operator, if any oprlsortop oid ! pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L) --- 2531,2572 ---- oprleft oid ! pg_type.oid Type of the left operand oprright oid ! pg_type.oid Type of the right operand oprresult oid ! pg_type.oid Type of the result oprcom oid ! pg_operator.oid Commutator of this operator, if any oprnegate oid ! pg_operator.oid Negator of this operator, if any oprlsortop oid ! pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L) *************** *** 2576,2582 **** oprrsortop oid ! pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R) --- 2576,2582 ---- oprrsortop oid ! pg_operator.oid If this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R) *************** *** 2586,2592 **** oprltcmpop oid ! pg_operator.oid If this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R) --- 2586,2592 ---- oprltcmpop 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,2602 **** oprgtcmpop oid ! pg_operator.oid If this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R) --- 2596,2602 ---- oprgtcmpop 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,2626 **** oprcode regproc ! pg_proc.oid Function that implements this operator oprrest regproc ! pg_proc.oid Restriction selectivity estimation function for this operator oprjoin regproc ! pg_proc.oid Join selectivity estimation function for this operator --- 2606,2626 ---- oprcode regproc ! pg_proc.oid Function that implements this operator oprrest regproc ! pg_proc.oid Restriction selectivity estimation function for this operator oprjoin regproc ! pg_proc.oid Join selectivity estimation function for this operator *************** *** 2679,2685 **** pronamespace oid ! pg_namespace.oid The OID of the namespace that contains this function --- 2679,2685 ---- pronamespace oid ! pg_namespace.oid The OID of the namespace that contains this function *************** *** 2688,2701 **** proowner int4 ! pg_shadow.usesysid Owner of the function prolang oid ! pg_language.oid Implementation language or call interface of this function --- 2688,2701 ---- proowner int4 ! pg_shadow.usesysid Owner of the function prolang oid ! pg_langauge.oid Implementation language or call interface of this function *************** *** 2763,2776 **** prorettype oid ! pg_type.oid Data type of the return value proargtypes oidvector ! pg_type.oid An array with the data types of the function arguments --- 2763,2776 ---- prorettype oid ! pg_type.oid Data type of the return value proargtypes oidvector ! pg_type.oid An array with the data types of the function arguments *************** *** 2852,2858 **** ev_class oid ! pg_class.oid The table this rule is for --- 2852,2858 ---- ev_class oid ! pg_class.oid The table this rule is for *************** *** 3083,3096 **** starelid oid ! pg_class.oid The table that the described column belongs to staattnum int2 ! pg_attribute.attnum The number of the described column --- 3083,3096 ---- starelid oid ! pg_class.oid The table that the described column belongs to staattnum int2 ! pg_attribute.attnum The number of the described column *************** *** 3135,3141 **** staopN oid ! pg_operator.oid An operator used to derive the statistics stored in the Nth slot. For example, a --- 3135,3141 ---- staopN oid ! pg_operator.oid An operator used to derive the statistics stored in the Nth slot. For example, a *************** *** 3204,3210 **** tgrelid oid ! pg_class.oid The table this trigger is on --- 3204,3210 ---- tgrelid oid ! pg_class.oid The table this trigger is on *************** *** 3218,3224 **** tgfoid oid ! pg_proc.oid The function to be called --- 3218,3224 ---- tgfoid oid ! pg_proc.oid The function to be called *************** *** 3255,3261 **** tgconstrrelid oid ! pg_class.oid The table referenced by an referential integrity constraint --- 3255,3261 ---- tgconstrrelid oid ! pg_class.oid The table referenced by an referential integrity constraint *************** *** 3347,3353 **** typnamespace oid ! pg_namespace.oid The OID of the namespace that contains this type --- 3347,3353 ---- typnamespace oid ! pg_namespace.oid The OID of the namespace that contains this type *************** *** 3356,3362 **** typowner int4 ! pg_shadow.usesysid Owner of the type --- 3356,3362 ---- typowner int4 ! pg_shadow.usesysid Owner of the type *************** *** 3428,3434 **** typrelid oid ! pg_class.oid If this is a composite type (see typtype), then this column points to --- 3428,3434 ---- typrelid oid ! pg_class.oid If this is a composite type (see typtype), then this column points to *************** *** 3444,3450 **** typelem oid ! pg_type.oid If typelem is not 0 then it identifies another row in pg_type. --- 3444,3450 ---- typelem oid ! pg_type.oid If typelem is not 0 then it identifies another row in pg_type. *************** *** 3466,3493 **** typinput regproc ! pg_proc.oid Input conversion function (text format) typoutput regproc ! pg_proc.oid Output conversion function (text format) typreceive regproc ! pg_proc.oid Input conversion function (binary format), or 0 if none typsend regproc ! pg_proc.oid Output conversion function (binary format), or 0 if none --- 3466,3493 ---- typinput regproc ! pg_proc.oid Input conversion function (text format) typoutput regproc ! pg_proc.oid Output conversion function (text format) typreceive regproc ! pg_proc.oid Input conversion function (binary format), or 0 if none typsend regproc ! pg_proc.oid Output conversion function (binary format), or 0 if none