Обсуждение: Error in the 9.1 documentation?
Hi, while going through the 9.1 new features, I think I have discovered an error in the manual regarding the CREATE TABLE command. It says: CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ] | table_constraint | LIKE parent_table [ like_option ... ] } [, ... ] Isn't there the element for DEFAULT missing for the column definition? Something like: column_name data_type [ DEFAULT default_expr ] [ COLLATE collation ] [ column_constraint [ ... ] ] Regards Thomas
On 7 May 2011 15:24, Thomas Kellerer <spam_eater@gmx.net> wrote: > Hi, > > while going through the 9.1 new features, I think I have discovered an error > in the manual regarding the CREATE TABLE command. > > It says: > > CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT > EXISTS ] table_name ( [ > { column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ] > | table_constraint > | LIKE parent_table [ like_option ... ] } > [, ... ] > > > Isn't there the element for DEFAULT missing for the column definition? > > Something like: > > column_name data_type [ DEFAULT default_expr ] [ COLLATE collation ] [ > column_constraint [ ... ] ] The DEFAULT declaration was moved into the column_constraint section. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Thom Brown wrote on 07.05.2011 16:28: >> while going through the 9.1 new features, I think I have discovered an error >> in the manual regarding the CREATE TABLE command. >> > The DEFAULT declaration was moved into the column_constraint section. > Ah thanks, didn't see that (and I wouldn't expect the DEFAULT to be listed as a constraint...) Regards Thomas