Disabling triggers in a transaction

Поиск
Список
Период
Сортировка
От Jay Guerette
Тема Disabling triggers in a transaction
Дата
Msg-id 4b9601ce05022714377ad0a14f@mail.gmail.com
обсуждение исходный текст
Ответы Re: Disabling triggers in a transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Disabling triggers in a transaction  (Terry Lee Tucker <terry@esc1.com>)
Список pgsql-general
If I disable INSERT and UPDATE triggers inside a transaction; by
setting and resetting reltriggers in pg_class; am I correct in
thinking that this will disable triggers globally for that table for
the duration of that transaction? So an INSERT or UPDATE to this
table, outside of the transaction and within that precise timeframe,
would NOT fire the trigger? If so, would the 'serializable ' isolation
level be required in order to ensure this doesn't happen?

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: hosting - asking for advice