Re: How to ALTER a TABLE to change the primary key?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to ALTER a TABLE to change the primary key?
Date: 2007-10-26 10:06:25
Message-ID: 4721BC21.4050701@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/26/07 04:39, Reg Me Please wrote:
> Hi all.
> I'd need to modify the primary key definition in an already populated table.
> How can I do it?

Have you tried dropping the constraint, and creating a new one?

http://www.postgresql.org/docs/8.2/interactive/sql-altertable.html

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHIbwhS9HxQb37XmcRAjg6AJ4sPW7wPH599JPVdmZ5s25b5yHnHQCeJtsr
0TRv9XcYy2+04FW+1dNIYFc=
=ldEW
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vince Negri 2007-10-26 10:25:09 TRUNCATE - timing of the return of disk space - caused by long-lived client?
Previous Message Reg Me Please 2007-10-26 09:39:46 How to ALTER a TABLE to change the primary key?