Обсуждение: 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