Re: Change primary key in Postgres 7.3?

On Tue, Oct 12, 2004 at 06:10:12PM -0700, Michael Hannon wrote:
>
> We expect that we WILL eventually rebuild the database, but right now
> we're looking for a quick fix.  Our current programmer tells me that he
> can't find a way to simply change the primary key "in place" in Postgres.

Does ALTER TABLE not work?

http://www.postgresql.org/docs/7.3/static/sql-altertable.html

Whatever you decide to do, hopefully you have a development system
on which to test your changes.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/