Re: Change primary key in Postgres 7.3?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Michael Hannon <jmh(at)physics(dot)ucdavis(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Change primary key in Postgres 7.3?
Date: 2004-10-13 02:09:10
Message-ID: 20041013020910.GA73056@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2004-10-13 02:42:14 Re: Change primary key in Postgres 7.3?
Previous Message Michael Glaesemann 2004-10-13 01:54:24 Re: Application user login/management