Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected

> Bruce Momjian writes:
>
> > o ALTER TABLE ADD COLUMN column SET DEFAULT should fill existing
> > rows with DEFAULT value or allow NULLs in existing rows
> >
> > My guess is that we will have to do spec behavior by default, and add a
> > flag to allow NULLs in existing rows.
>
> May I point you to the already existing set of commands that do exactly
> what you want:
>
> ALTER TABLE t1 ADD COLUMN name type;
> ALTER TABLE t1 ALTER COLUMN name SET DEFAULT foo;
>
> There's no reason to muck around with the spec here.

OK, so we will implement the spec, and allow people to avoid the
double-disk space by doing the steps manually and skipping the UPDATE.
Sounds good to me. TODO updated.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026