Tom Lane wrote:
>
> "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"?
>
*ALTER TABLE* isn't as easy as *CREATE TABLE*.
It has another problem because it hasn't implemented
*DEFAULT* yet.
regards,
Hiroshi Inoue