Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding a Column: default values now allowed - Mailing list pgsql-docs

From Tom Lane
Subject Re: Adding a Column: default values now allowed
Date
Msg-id 27705.1105289862@sss.pgh.pa.us
Whole thread Raw
In response to Adding a Column: default values now allowed  (Michael Fuhr <mike@fuhr.org>)
List pgsql-docs
Tree view 
Michael Fuhr <mike@fuhr.org> writes:
> PostgreSQL 8.0.0rc4
> 5.6.1 "Adding a Column" says:

>   Also, you cannot define a default value on a new column.  According
>   to the SQL standard, this would have to fill the new columns in the
>   existing rows with the default value, which is not implemented yet.

Drat, I thought I'd caught all those.  Thanks.

            regards, tom lane

pgsql-docs by date:

Previous
From: Michael Fuhr
Date:
Subject: Adding a Column: default values now allowed
Next
From: "Jérôme Colombié"
Date:
Subject: Tablespace documentation