Re: add column .. default

On Thu, 2003-06-19 at 10:05, Alvaro Herrera wrote:
> On Thu, Jun 19, 2003 at 09:52:14AM -0400, Rod Taylor wrote:
> > On Thu, 2003-06-19 at 09:40, Tom Lane wrote:
>
> > Do we want them to? If we don't mind them being executed, it is far
> > easier to:
> >
> > - alter table structure
> > - Add all new constraints (without confirming their correctness at that
> > time)
> > - update table contents via an SPI call to UPDATE WHERE <column> IS NULL
>
> Sorry, I haven't read the spec, but what happens when there is a default
> value already and it's not NULL? Are tuples where column = default
> updated? Are tuples where column IS NULL updated?

We're talking about add column. Since it's a new column, there will
never be a default and all entries are NULL in PostgreSQL.

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc