Re: ALTER TABLE ADD COLUMN column SERIAL -- unexpected results

> "Rod Taylor" <rbt(at)barchord(dot)com> writes:
> > Running:
> > ALTER TABLE table ADD COLUMN column SERIAL;
> > Defines a column as int4 but does not create the sequence or attempt
> > to set the default value.
>
> Yeah ... SERIAL is implemented as a hack in the parsing of CREATE
> TABLE, but there's no corresponding hack in ALTER TABLE. A bug,
> no doubt about it, but I don't much like the obvious fix of duplicating
> the hack in two places. Isn't there a cleaner way to deal with this
> "data type"?

Added to TODO.

--
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