From 46bb23ac016714065711cf2a780e080c7310d66e Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 13 Aug 2002 20:40:44 +0000 Subject: Change NAMEDATALEN to 64, INDEX_MAX_KEYS/MAX_FUNC_ARGS to 32, per discussion on hackers. --- doc/src/sgml/datatype.sgml | 8 ++++---- doc/src/sgml/indices.sgml | 4 ++-- doc/src/sgml/manage.sgml | 4 ++-- doc/src/sgml/ref/create_index.sgml | 4 ++-- doc/src/sgml/ref/current_user.sgml | 4 ++-- doc/src/sgml/ref/listen.sgml | 4 ++-- doc/src/sgml/ref/notify.sgml | 4 ++-- doc/src/sgml/ref/unlisten.sgml | 4 ++-- doc/src/sgml/start.sgml | 4 ++-- doc/src/sgml/syntax.sgml | 6 +++--- 10 files changed, 23 insertions(+), 23 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index ce735827b40..bf53769a1e0 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ @@ -914,7 +914,7 @@ SELECT b, char_length(b) FROM test2; PostgreSQL. The name type exists only for storage of internal catalog names and is not intended for use by the general user. Its length - is currently defined as 32 bytes (31 usable characters plus terminator) + is currently defined as 64 bytes (63 usable characters plus terminator) but should be referenced using the macro NAMEDATALEN. The length is set at compile time (and is therefore adjustable for special uses); the default @@ -943,8 +943,8 @@ SELECT b, char_length(b) FROM test2; name - 32 bytes - Thirty-one character internal type + 64 bytes + Sixty-three character internal type diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 0d39014d32e..e4812e70281 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -1,4 +1,4 @@ - + Indexes @@ -236,7 +236,7 @@ CREATE INDEX test2_mm_idx ON test2 (major, minor); Currently, only the B-tree and GiST implementations support multicolumn - indexes. Up to 16 columns may be specified. (This limit can be + indexes. Up to 32 columns may be specified. (This limit can be altered when building PostgreSQL; see the file pg_config.h.) diff --git a/doc/src/sgml/manage.sgml b/doc/src/sgml/manage.sgml index 786adb71965..1850b7481ea 100644 --- a/doc/src/sgml/manage.sgml +++ b/doc/src/sgml/manage.sgml @@ -1,5 +1,5 @@ @@ -70,7 +70,7 @@ ERROR: CREATE DATABASE: Permission denied. You automatically become the database administrator of the database you just created. Database names must have an alphabetic first - character and are limited to 31 characters in length. + character and are limited to 63 characters in length. PostgreSQL allows you to create any number of databases at a given site. diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index ce04dde81fc..2144eaa2dd3 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -1,5 +1,5 @@ @@ -339,7 +339,7 @@ ERROR: Cannot create index: 'index_name' already exists. Currently, only the B-tree and gist access methods support multicolumn - indexes. Up to 16 keys may be specified by default (this limit + indexes. Up to 32 keys may be specified by default (this limit can be altered when building PostgreSQL). Only B-tree currently supports unique indexes. diff --git a/doc/src/sgml/ref/current_user.sgml b/doc/src/sgml/ref/current_user.sgml index d358dd8c43d..630728da9dd 100644 --- a/doc/src/sgml/ref/current_user.sgml +++ b/doc/src/sgml/ref/current_user.sgml @@ -1,5 +1,5 @@ @@ -77,7 +77,7 @@ The name of the current user. Notes - Data type "name" is a non-standard 31-character type for storing + Data type "name" is a non-standard 63-character type for storing system identifiers. diff --git a/doc/src/sgml/ref/listen.sgml b/doc/src/sgml/ref/listen.sgml index 405e6fb0e21..ac610585ca6 100644 --- a/doc/src/sgml/ref/listen.sgml +++ b/doc/src/sgml/ref/listen.sgml @@ -1,5 +1,5 @@ @@ -146,7 +146,7 @@ WARNING: Async_Listen: We are already listening on notifyname is enclosed in double-quotes, it need not even be a syntactically - valid name, but can be any string up to 31 characters long. + valid name, but can be any string up to 63 characters long. In some previous releases of diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index e21121dabd8..a7a7df058de 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -1,5 +1,5 @@ @@ -180,7 +180,7 @@ NOTIFY it need not correspond to the name of any actual table. If name is enclosed in double-quotes, it need not even be a syntactically - valid name, but can be any string up to 31 characters long. + valid name, but can be any string up to 63 characters long. In some previous releases of diff --git a/doc/src/sgml/ref/unlisten.sgml b/doc/src/sgml/ref/unlisten.sgml index 07d3db1ec9e..1abe7c3b418 100644 --- a/doc/src/sgml/ref/unlisten.sgml +++ b/doc/src/sgml/ref/unlisten.sgml @@ -1,5 +1,5 @@ @@ -114,7 +114,7 @@ UNLISTEN { notifyname | * } notifyname need not be a valid class name but can be any string valid - as a name up to 32 characters long. + as a name up to 64 characters long. The backend does not complain if you UNLISTEN something you were not diff --git a/doc/src/sgml/start.sgml b/doc/src/sgml/start.sgml index a1adb712ce1..f4ca77fe1f8 100644 --- a/doc/src/sgml/start.sgml +++ b/doc/src/sgml/start.sgml @@ -1,5 +1,5 @@ @@ -231,7 +231,7 @@ createdb: database creation failed You can also create databases with other names. PostgreSQL allows you to create any number of databases at a given site. Database names must have an - alphabetic first character and are limited to 31 characters in + alphabetic first character and are limited to 63 characters in length. A convenient choice is to create a database with the same name as your current user name. Many tools assume that database name as the default, so it can save you some typing. To create diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml index fbbe78db9a8..a99a526db18 100644 --- a/doc/src/sgml/syntax.sgml +++ b/doc/src/sgml/syntax.sgml @@ -1,5 +1,5 @@ @@ -120,8 +120,8 @@ INSERT INTO MY_TABLE VALUES (3, 'hi there'); The system uses no more than NAMEDATALEN-1 characters of an identifier; longer names can be written in commands, but they will be truncated. By default, - NAMEDATALEN is 32 so the maximum identifier length - is 31 (but at the time the system is built, + NAMEDATALEN is 64 so the maximum identifier length + is 63 (but at the time the system is built, NAMEDATALEN can be changed in src/include/postgres_ext.h). -- cgit v1.2.3