From 739adf32eecfe129aea09f543370d886045c7c01 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 24 Jul 2002 19:11:14 +0000 Subject: Remove unused system table columns: pg_language.lancompiler pg_operator.oprprec pg_operator.oprisleft pg_proc.proimplicit pg_proc.probyte_pct pg_proc.properbyte_cpu pg_proc.propercall_cpu pg_proc.prooutin_ratio pg_shadow.usetrace pg_type.typprtlen pg_type.typreceive pg_type.typsend Attempts to use the obsoleted attributes of pg_operator or pg_proc in the CREATE commands will be greeted by a warning. For pg_type, there is no warning (yet) because pg_dump scripts still contain these attributes. Also remove new but already obsolete spellings isVolatile, isStable, isImmutable in WITH clause. (Use new syntax instead.) --- doc/src/sgml/catalogs.sgml | 88 +---------------------------------- doc/src/sgml/ref/create_function.sgml | 9 +--- doc/src/sgml/ref/create_language.sgml | 13 +++--- doc/src/sgml/ref/create_type.sgml | 53 +-------------------- 4 files changed, 10 insertions(+), 153 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 1ec90fd5ae4..5ef29364533 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,6 +1,6 @@ @@ -1734,13 +1734,6 @@ - - lancompiler - text - - not currently used - - lanacl aclitem[] @@ -1976,14 +1969,6 @@ Owner (creator) of the operator - - oprprec - int2 - - precedence (currently unused, as precedences are hard-wired - in the grammar) - - oprkind char @@ -1994,14 +1979,6 @@ - - oprisleft - bool - - left-associativity (currently unused, as this is hard-wired - in the grammar) - - oprcanhash bool @@ -2185,13 +2162,6 @@ not functional - - proimplicit - bool - - Function may be invoked as an implicit type coercion - - proisstrict bool @@ -2252,34 +2222,6 @@ A vector with the data types of the function arguments - - probyte_pct - int4 - - dead code - - - - properbyte_cpu - int4 - - dead code - - - - propercall_cpu - int4 - - dead code - - - - prooutin_ratio - int4 - - dead code - - prosrc text @@ -2471,13 +2413,6 @@ User may create databases - - usetrace - bool - - not used - - usesuper bool @@ -2843,13 +2778,6 @@ Length of the storage representation of the type, -1 if variable length - - typprtlen - int2 - - unused - - typbyval bool @@ -2952,20 +2880,6 @@ Output function - - typreceive - regproc - pg_proc.oid - unused - - - - typsend - regproc - pg_proc.oid - unused - - typalign char diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index e2170dcc45d..2c618140c85 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ @@ -257,16 +257,11 @@ CREATE [ OR REPLACE ] FUNCTION name - isImmutable isCachable - isStable - isVolatile - Equivalent to IMMUTABLE, - STABLE, VOLATILE. isCachable is an obsolete equivalent of - isImmutable; it's still accepted for + IMMUTABLE; it's still accepted for backwards-compatibility reasons. diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 1871da57e56..1431c32fc5a 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -1,5 +1,5 @@ @@ -221,14 +221,13 @@ ERROR: PL handler function funcname diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index 042a8fd51d6..d4860cff80d 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -1,5 +1,5 @@ @@ -24,10 +24,8 @@ PostgreSQL documentation CREATE TYPE typename ( INPUT = input_function, OUTPUT = output_function , INTERNALLENGTH = { internallength | VARIABLE } - [ , EXTERNALLENGTH = { externallength | VARIABLE } ] [ , DEFAULT = default ] [ , ELEMENT = element ] [ , DELIMITER = delimiter ] - [ , SEND = send_function ] [ , RECEIVE = receive_function ] [ , PASSEDBYVALUE ] [ , ALIGNMENT = alignment ] [ , STORAGE = storage ] @@ -63,16 +61,6 @@ CREATE TYPE typename ( INPUT = - - externallength - - - A literal value, which specifies the external (displayed) length of - the new type. - - - - input_function @@ -126,26 +114,6 @@ CREATE TYPE typename ( INPUT = - - send_function - - - The name of a function, created by CREATE FUNCTION, which - converts data of this type into a form suitable for - transmission to another machine. - - - - - receive_function - - - The name of a function, created by CREATE FUNCTION, which - converts data of this type from a form suitable for - transmission from another machine to internal form. - - - alignment @@ -259,13 +227,6 @@ CREATE TYPE length of this value of the type. - - The external representation length is similarly specified using the - externallength - keyword. (This value is not presently used, and is typically omitted, - letting it default to .) - - To indicate that a type is an array, specify the type of the array @@ -292,18 +253,6 @@ CREATE TYPE clause attached to a particular column.) - - The optional arguments - send_function and - receive_function - are not currently used, and are usually omitted (allowing them - to default to the - output_function and - input_function - respectively). These functions may someday be resurrected for use - in specifying machine-independent binary representations. - - The optional flag, , indicates that values of this data type are passed -- cgit v1.2.3