Request a Demo
Home   >   mailing lists

Re: How to ALTER a TABLE to change the primary key? - Mailing list pgsql-general

From Ron Johnson
Subject Re: How to ALTER a TABLE to change the primary key?
Date
Msg-id 4721BC21.4050701@cox.net
Whole thread Raw
In response to How to ALTER a TABLE to change the primary key?  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
Tree view 
-----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-----

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: How to ALTER a TABLE to change the primary key?
Next
From: "Vince Negri"
Date:
Subject: TRUNCATE - timing of the return of disk space - caused by long-lived client?