Re: Enable/Disable Triggers

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Enable/Disable Triggers
Дата
Msg-id 20110315213342.GE76699@shinkuro.com
обсуждение исходный текст
Ответ на Enable/Disable Triggers  ("Andy Chambers" <achambers@mcna.net>)
Список pgsql-general
On Tue, Mar 15, 2011 at 05:01:50PM -0400, Andy Chambers wrote:
> Is it a big no-no to enable/disable triggers by manually setting
> pg_trigger.tgenabled to 'D'?

No, but I seem to recall having seen corner cases where it didn't
work.  (This was the reason that in older versions of slony, slony
fooled with the system catalogues instead.)

You can use the replication_role control to prevent triggers firing.

A

--
Andrew Sullivan
ajs@crankycanuck.ca

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

Предыдущее
От: Alexander Farber
Дата:
Сообщение: A join of 2 tables with sum(column) > 30
Следующее
От: Vibhor Kumar
Дата:
Сообщение: Re: Enable/Disable Triggers