Re: temporarily disabling foreign keys

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: temporarily disabling foreign keys
Дата
Msg-id BANLkTimnBBp1Vm+d0P9seMiY9TXQJOXtDw@mail.gmail.com
обсуждение исходный текст
Ответ на temporarily disabling foreign keys  (Seb <spluque@gmail.com>)
Список pgsql-general
in recent versions of postgres, there is a "replication" mode designed
specifically for replication software to disable FK's and other
triggers.  Perhaps investigate that.

the other option is to make your FK's deferrable, and do all your
delete in one big transaction with the FK checks deferred.  not sure
if that will help.

either that, or order your deletes and loads in a way such that the
FKs remain satisfied.  unless you have circular dependencies, this
should be possible.

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

Предыдущее
От: Seb
Дата:
Сообщение: temporarily disabling foreign keys
Следующее
От: John R Pierce
Дата:
Сообщение: Re: temporarily disabling foreign keys