Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 26 Oct 2007 05:06:25 -0500
-----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-----
- References:
- How to ALTER a TABLE to change the primary key?
- From: Reg Me Please
- How to ALTER a TABLE to change the primary key?
- Prev by Date: How to ALTER a TABLE to change the primary key?
- Next by Date: TRUNCATE - timing of the return of disk space - caused by long-lived client?
- Previous by thread: How to ALTER a TABLE to change the primary key?
- Next by thread: Re: How to ALTER a TABLE to change the primary key?
- Indexes: