Re: Adding a Column: default values now allowed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Adding a Column: default values now allowed
Date: 2005-01-09 16:57:42
Message-ID: 27705.1105289862@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2005-01-09 20:18:00 Re: Regexp matching: bug or operator error?
Previous Message Michael Fuhr 2005-01-09 07:41:56 Adding a Column: default values now allowed