Re: pg_dump bug in 7.3.9 with sequences

"Joshua D. Drake" <jd@commandprompt.com> writes:
> However if you do the following:

> create table foo (foo serial not null, bar text);
> create sequence foo_seq;
> alter table foo alter column foo set default nextval('foo_seq');

This is flat out pilot error: you do not get to mess with the default
expression of a SERIAL column, because it's part of the internal
implementation of the SERIAL pseudo-type.  If I were going to do
anything about it, I'd patch ALTER TABLE to refuse the above command.
        regards, tom lane