Re: Change primary key in Postgres 7.3? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Change primary key in Postgres 7.3?
Date
Msg-id 20041013020910.GA73056@winnie.fuhr.org
Whole thread Raw
In response to Change primary key in Postgres 7.3?  (Michael Hannon <jmh@physics.ucdavis.edu>)
Responses Re: Change primary key in Postgres 7.3?  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
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/

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Application user login/management
Next
From: Mike Mascari
Date:
Subject: Re: Change primary key in Postgres 7.3?