Disabling triggers in a transaction

Поиск
Список
Период
Сортировка
Искать
От
Jay Guerette
Тема
Disabling triggers in a transaction
Дата
Msg-id
4b9601ce05022714377ad0a14f@mail.gmail.com
Список
Дерево обсуждения
Disabling triggers in a transaction Jay Guerette <jayguerette@gmail.com>
Re: Disabling triggers in a transaction Terry Lee Tucker <terry@esc1.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>
Re: Disabling triggers in a transaction Geoffrey <esoteric@3times25.net>
Re: Disabling triggers in a transaction Bruce Momjian <pgman@candle.pha.pa.us>
Re: Disabling triggers in a transaction Adam Tomjack <adamtj@adamtj.org> 
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
Дата:
Следующее
От: Bruno Wolff III
Дата:
FAQ