-----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----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster