Changing constraints to deferrable

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Changing constraints to deferrable
Дата
Msg-id 873bunbkzj.fsf@stark.xeocode.com
обсуждение исходный текст
Ответы Re: Changing constraints to deferrable  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Changing constraints to deferrable  ("Florian G. Pflug" <fgp@phlo.org>)
Список pgsql-general
I want all my foreign key constraints to be deferrable. They were all created
with the default (not deferrable).

Is it enough to just do

  update pg_constraint set condeferrable = 't' where contype = 'f';

?

It doesn't seem to be enough. I still get constraint violations as soon as I
try to delete a referenced column even after "set constraints all deferred".


--
greg

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Using rule with function for view delete gives error on OLD.* type
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Constraint problem