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

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: How to ALTER a TABLE to change the primary key?
Дата
Msg-id 4721BC21.4050701@cox.net
обсуждение исходный текст
Ответ на How to ALTER a TABLE to change the primary key?  (Reg Me Please <regmeplease@gmail.com>)
Список 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-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Reg Me Please
Дата:
Сообщение: How to ALTER a TABLE to change the primary key?
Следующее
От: "Vince Negri"
Дата:
Сообщение: TRUNCATE - timing of the return of disk space - caused by long-lived client?