Re: pg_dump + serial + sequence problem - Mailing list pgsql-bugs

"Luiz K. Matsumura" <luiz@planit.com.br> writes:
> CREATE TABLE teste
> (
>    id serial,
>    ...
> ALTER TABLE teste  ALTER COLUMN id DROP DEFAULT;

This isn't supported before 8.2, since as you found out pg_dump is
unable to reproduce the situation in the database --- the sequence is
still marked as "owned by" the column even though there's no default
anymore.  We aren't going to try to fix that behavior in the older
branches.

            regards, tom lane