diff options
Diffstat (limited to 'doc/src/sgml')
-rw-r--r-- | doc/src/sgml/datatype.sgml | 8 | ||||
-rw-r--r-- | doc/src/sgml/indices.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/manage.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/ref/current_user.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/ref/listen.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/ref/notify.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/ref/unlisten.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/start.sgml | 4 | ||||
-rw-r--r-- | doc/src/sgml/syntax.sgml | 6 |
10 files changed, 23 insertions, 23 deletions
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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.97 2002/08/05 19:43:30 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.98 2002/08/13 20:40:43 momjian Exp $ --> <chapter id="datatype"> @@ -914,7 +914,7 @@ SELECT b, char_length(b) FROM test2; <productname>PostgreSQL</productname>. The <type>name</type> type exists <emphasis>only</emphasis> 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 <symbol>NAMEDATALEN</symbol>. 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; </row> <row> <entry>name</entry> - <entry>32 bytes</entry> - <entry>Thirty-one character internal type</entry> + <entry>64 bytes</entry> + <entry>Sixty-three character internal type</entry> </row> </tbody> </tgroup> 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 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.35 2002/07/30 17:34:37 tgl Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.36 2002/08/13 20:40:43 momjian Exp $ --> <chapter id="indexes"> <title id="indexes-title">Indexes</title> @@ -236,7 +236,7 @@ CREATE INDEX test2_mm_idx ON test2 (major, minor); <para> 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 <productname>PostgreSQL</productname>; see the file <filename>pg_config.h</filename>.) </para> 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/Attic/manage.sgml,v 1.22 2002/08/10 19:35:00 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/Attic/manage.sgml,v 1.23 2002/08/13 20:40:43 momjian Exp $ --> <Chapter Id="manage"> @@ -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. <ProductName>PostgreSQL</ProductName> allows you to create any number of databases at a given site. </Para> 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.35 2002/07/30 17:34:37 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_index.sgml,v 1.36 2002/08/13 20:40:43 momjian Exp $ PostgreSQL documentation --> @@ -339,7 +339,7 @@ ERROR: Cannot create index: 'index_name' already exists. <para> 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 <application>PostgreSQL</application>). 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/current_user.sgml,v 1.6 2002/04/21 19:02:39 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/current_user.sgml,v 1.7 2002/08/13 20:40:43 momjian Exp $ PostgreSQL documentation --> @@ -77,7 +77,7 @@ The name of the current user. Notes </TITLE> <PARA> - 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. </PARA> </REFSECT2> 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/listen.sgml,v 1.13 2002/04/21 19:02:39 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/listen.sgml,v 1.14 2002/08/13 20:40:43 momjian Exp $ PostgreSQL documentation --> @@ -146,7 +146,7 @@ WARNING: Async_Listen: We are already listening on <replaceable class="PARAMETE it need not correspond to the name of any actual table. If <replaceable class="PARAMETER">notifyname</replaceable> 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. </para> <para> 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/notify.sgml,v 1.17 2002/04/21 19:02:39 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/notify.sgml,v 1.18 2002/08/13 20:40:44 momjian Exp $ PostgreSQL documentation --> @@ -180,7 +180,7 @@ NOTIFY it need not correspond to the name of any actual table. If <replaceable class="PARAMETER">name</replaceable> 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. </para> <para> 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/unlisten.sgml,v 1.18 2002/04/21 19:02:39 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/unlisten.sgml,v 1.19 2002/08/13 20:40:44 momjian Exp $ PostgreSQL documentation --> @@ -114,7 +114,7 @@ UNLISTEN { <replaceable class="PARAMETER">notifyname</replaceable> | * } <para> <replaceable class="PARAMETER">notifyname</replaceable> 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. </para> <para> 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/start.sgml,v 1.23 2002/08/10 19:35:00 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/start.sgml,v 1.24 2002/08/13 20:40:43 momjian Exp $ --> <chapter id="tutorial-start"> @@ -231,7 +231,7 @@ createdb: database creation failed You can also create databases with other names. <productname>PostgreSQL</productname> 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 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.65 2002/08/10 19:01:53 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/syntax.sgml,v 1.66 2002/08/13 20:40:43 momjian Exp $ --> <chapter id="sql-syntax"> @@ -120,8 +120,8 @@ INSERT INTO MY_TABLE VALUES (3, 'hi there'); The system uses no more than <symbol>NAMEDATALEN</symbol>-1 characters of an identifier; longer names can be written in commands, but they will be truncated. By default, - <symbol>NAMEDATALEN</symbol> is 32 so the maximum identifier length - is 31 (but at the time the system is built, + <symbol>NAMEDATALEN</symbol> is 64 so the maximum identifier length + is 63 (but at the time the system is built, <symbol>NAMEDATALEN</symbol> can be changed in <filename>src/include/postgres_ext.h</filename>). </para> |