Re: Error in the 9.1 documentation?

On 7 May 2011 15:24, Thomas Kellerer <spam_eater(at)gmx(dot)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