Re: alter table serial->int - Mailing list pgsql-admin

CREATE TABLE x (
   a serial NOT NULL
);

alter table x alter a drop default;

alter table x alter a set default 999;

still doesn't help.

i supposed i can dump the whole table and rebuild it.... but that's
going to be a bit slow.