Re: Changing constraints to deferrable

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Changing constraints to deferrable
Дата
Msg-id 20050323201341.GB53187@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: Changing constraints to deferrable  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Changing constraints to deferrable  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
On Wed, Mar 23, 2005 at 12:13:33PM -0500, Greg Stark wrote:
>
> Consider this a plea for an ALTER TABLE ALTER CONSTRAINT command :)

Shouldn't ALTER TABLE DROP CONSTRAINT followed by ALTER TABLE ADD
CONSTRAINT work?  It does for me in simple tests.  It's a little
more work than a single ALTER TABLE ALTER CONSTRAINT would be, but
it's less hackish than updating the system catalogs directly.  Or
am I missing something?

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

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

Предыдущее
От: "Jim Buttafuoco"
Дата:
Сообщение: Re: inherited table and rules
Следующее
От: Tom Lane
Дата:
Сообщение: Re: debug_print_plan