Re: alter table serial->int

["Erik Aronesty" <erik@xxxxxxx>]

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.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend