Re: Change primary key in Postgres 7.3?

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Change primary key in Postgres 7.3?
Дата
Msg-id 20041013020910.GA73056@winnie.fuhr.org
обсуждение исходный текст
Ответ на Change primary key in Postgres 7.3?  (Michael Hannon <jmh@physics.ucdavis.edu>)
Ответы Re: Change primary key in Postgres 7.3?  (Mike Mascari <mascarm@mascari.com>)
Список pgsql-general
On Tue, Oct 12, 2004 at 06:10:12PM -0700, Michael Hannon wrote:
>
> We expect that we WILL eventually rebuild the database, but right now
> we're looking for a quick fix.  Our current programmer tells me that he
> can't find a way to simply change the primary key "in place" in Postgres.

Does ALTER TABLE not work?

http://www.postgresql.org/docs/7.3/static/sql-altertable.html

Whatever you decide to do, hopefully you have a development system
on which to test your changes.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Application user login/management
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: Change primary key in Postgres 7.3?