diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-05-04 00:03:55 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-05-04 00:03:55 +0000 |
| commit | ac5fdea6877acd8d646feac8fae78675ad5e294d (patch) | |
| tree | 517451e2385bcbfa0047e19e374fd3e0e9c802df /doc/src/sgml/ref/create_table_as.sgml | |
| parent | 228697179adac8da31e0a832e730d0927cf6d0c1 (diff) | |
When a TIMESTAMP, TIME, or INTERVAL precision is specified larger than our
implementation limits, do not issue an ERROR; instead issue a NOTICE and use
the max supported value. Per pgsql-general discussion of 28-Apr, this is
needed to allow easy porting from pre-7.3 releases where the limits were
higher.
Unrelated change in same area: accept GLOBAL TEMP/TEMPORARY as a synonym
for TEMPORARY, as per pgsql-hackers discussion of 15-Apr. We previously
rejected it, but that was based on a misreading of the spec --- SQL92's
GLOBAL temp tables are really closer to what we have than their LOCAL ones.
Diffstat (limited to 'doc/src/sgml/ref/create_table_as.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_table_as.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index cc30ce0e3f7..d298e1a5ea1 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.12 2003/04/22 10:08:08 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table_as.sgml,v 1.13 2003/05/04 00:03:55 tgl Exp $ PostgreSQL documentation --> @@ -16,7 +16,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name</replaceable> [ (<replaceable>column_name</replaceable> [, ...] ) ] +CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name</replaceable> [ (<replaceable>column_name</replaceable> [, ...] ) ] AS <replaceable>query</replaceable> </synopsis> </refsynopsisdiv> @@ -49,7 +49,7 @@ CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable>table_name</replace <variablelist> <varlistentry> - <term><literal>[LOCAL] TEMPORARY</> or <literal>[LOCAL] TEMP</></term> + <term><literal>TEMPORARY</> or <literal>TEMP</></term> <listitem> <para> If specified, the table is created as a temporary table. |