Re: Sequences/defaults and pg_dump - Mailing list pgsql-general

Nikolay Samokhvalov <samokhvalov@gmail.com> writes:
> testseq=# CREATE TABLE test(id SERIAL, data TEXT);
> NOTICE:  CREATE TABLE will create implicit sequence "test_id_seq" for
> serial column "test.id"
> CREATE TABLE
> ***
> ALTER TABLE test ALTER COLUMN id SET DEFAULT nextval('test_id_seq') * 10;

The correct solution to this is to forbid ALTER COLUMN SET DEFAULT on
a serial column, but we haven't gotten around to enforcing that yet.

            regards, tom lane