From e92bec2844f2da02d217d18cb7260cf04f05c43e Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 24 Sep 2002 21:26:44 +0000 Subject: Update some obsolete comments and column descriptions. --- doc/src/sgml/catalogs.sgml | 121 ++++++++++++++++++++++----------------------- 1 file changed, 60 insertions(+), 61 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 1a3765ab633..f71c3bc74b2 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,6 +1,6 @@ @@ -232,7 +232,7 @@ aggfinalfn regproc pg_proc.oid - Final function + Final function (zero if none) aggtranstype @@ -685,9 +685,9 @@ int2 - This is a copy of the + This is a copy of pg_type.typlen - for this column's type. + of this column's type. @@ -732,9 +732,8 @@ atttypmod records type-specific data supplied at table creation time (for example, the maximum length of a varchar column). It is passed to - type-specific input and output functions as the third - argument. The value will generally be -1 for types that do not - need typmod. + type-specific input functions and length coercion functions. + The value will generally be -1 for types that do not need typmod. @@ -754,9 +753,10 @@ char - A copy of + Normally a copy of pg_type.typstorage - of this column's type + of this column's type. For TOASTable datatypes, this can be altered + after column creation to control storage policy. @@ -922,7 +922,7 @@ table. This includes indexes (but see also pg_index), sequences, views, and some kinds of special relation; see relkind. -. Below, when we mean all of these + Below, when we mean all of these kinds of objects we speak of relations. Not all fields are meaningful for all relation types. @@ -1287,14 +1287,14 @@ conkey - smallint[] + int2[] pg_attribute.attnum If a table constraint, list of columns which the constraint constrains confkey - smallint[] + int2[] pg_attribute.attnum If a foreign key, list of the referenced columns @@ -1448,7 +1448,7 @@ datdba int4 pg_shadow.usesysid - Owner of the database, initially who created it + Owner of the database, usually the user who created it @@ -1584,7 +1584,7 @@ objsubid - integer + int4 For a table attribute, this is the attribute's column number (the objid and classid refer to the table itself). @@ -1608,10 +1608,10 @@ refobjsubid - integer + int4 For a table attribute, this is the attribute's - column number (the objid and classid refer to the table itself). + column number (the refobjid and refclassid refer to the table itself). For all other object types, this field is presently zero. @@ -1694,10 +1694,10 @@ The pg_description table can store an optional description or comment for each database object. Descriptions can be manipulated - with the COMMENT command. Client applications - can view the descriptions by joining with this table. Many built-in - system objects have comments associated with them that are shown by + with the COMMENT command and viewed with psql's \d commands. + Descriptions of many built-in system objects are provided in the initial + contents of pg_description. @@ -1837,21 +1837,22 @@ indexrelidoidpg_class.oid - The oid of the pg_class entry for this index + 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 + The OID of the pg_class entry for the table this index is for indproc regproc pg_proc.oid - The registered procedure if this is a functional index + The function's OID if this is a functional index, + else zero @@ -1863,7 +1864,9 @@ INDEX_MAX_KEYS values that indicate which table columns this index pertains to. For example a value of 1 3 would mean that the first and the third - column make up the index key. + column make up the index key. For a functional index, these + columns are the inputs to the function, and the function's return + value is the index key. @@ -1912,7 +1915,8 @@ textExpression tree (in the form of a nodeToString representation) - for partial index predicate + for partial index predicate. Empty string if not a partial + index. @@ -1947,9 +1951,7 @@ oidpg_class.oid - This is the reference to the subtable, that is, it records the - fact that the identified table is inherited from some other - table. + The OID of the child table. @@ -1958,9 +1960,7 @@ oidpg_class.oid - This is the reference to the parent table, which the table - referenced by inhrelid inherited - from. + The OID of the parent table. @@ -1969,7 +1969,7 @@ int4 - If there is more than one parent for a subtable (multiple + If there is more than one parent for a child table (multiple inheritance), this number tells the order in which the inherited columns are to be arranged. The count starts at 1. @@ -2511,6 +2511,11 @@
+ + Unused fields contain zeroes, for example oprleft is zero for a + prefix operator. + + @@ -2582,10 +2587,11 @@ - proistrusted + prosecdef bool - not functional + Function is a security definer (i.e., a setuid + function) @@ -2638,7 +2644,7 @@ prorettype oid pg_type.oid - Data type of the return value (0 if the function does not return a value) + Data type of the return value @@ -2721,14 +2727,6 @@ Rule name - - ev_type - char - - Event type that the rule is for: '1' = SELECT, - '2' = UPDATE, '3' = INSERT, '4' = DELETE - - ev_class oid @@ -2744,6 +2742,14 @@ indicate the whole table) + + ev_type + char + + Event type that the rule is for: '1' = SELECT, + '2' = UPDATE, '3' = INSERT, '4' = DELETE + + is_instead bool @@ -3054,7 +3060,7 @@ tgname name - Trigger name (need not be unique) + Trigger name (must be unique among triggers of same table) @@ -3084,7 +3090,7 @@ tgisconstraint bool - True if trigger is a RI constraint + True if trigger implements an RI constraint @@ -3251,7 +3257,7 @@ True if the type is defined, false if this is a placeholder entry for a not-yet-defined type. When typisdefined is false, - nothing except the type name and OID can be relied on. + nothing except the type name, namespace, and OID can be relied on. @@ -3306,14 +3312,14 @@ typinput regproc pg_proc.oid - Input function + Input conversion function typoutput regproc pg_proc.oid - Output function + Output conversion function @@ -3417,15 +3423,10 @@ int4 - typtypmod records type-specific data - supplied at table creation time (for example, the maximum - length of a varchar column). It is passed to - type-specific input and output functions as the third - argument. The value will generally be -1 for types that do not - need typmod. This value is copied to - pg_attribute.atttypmod when - creating a column of a domain type. - + Domains use typtypmod to record the typmod + to be applied to their base type (-1 if base type does not use a + typmod). -1 if this type is not a domain. + @@ -3434,11 +3435,9 @@ typndims is the number of array dimensions - for a domain that is an array. (The array element type is - typbasetype.) Zero for non-domains and non-array domains. - This value is copied to - pg_attribute.attndims when - creating a column of a domain type. + for a domain that is an array (that is, typbasetype is an array type; + the domain's typelem will match the base type's typelem). + Zero for non-domains and non-array domains. -- cgit v1.2.3