Re: alter table serial->int

From: "Erik Aronesty" <erik(at)q32(dot)com>
To: "Erik Aronesty" <erik(at)q32(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: alter table serial->int
Date: 2007-11-11 12:15:01
Message-ID: ccd588d90711110415n40a61249pbcb67cf5d4c73f0d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-11-11 15:37:11 Re: alter table serial->int
Previous Message Brendan Duddridge 2007-11-11 08:46:21 Re: shared memory settings on MAC OS X