Re: disable triggers isolated to transaction only?

Поиск
Список
Период
Сортировка
Искать
От
Ben Chobot
Тема
Re: disable triggers isolated to transaction only?
Дата
Msg-id
B06047F7-57AD-4D5D-8C96-B55CBC6D7C92@silentmedia.com
Ответ на
disable triggers isolated to transaction only? (Vick Khera)
Список
Дерево обсуждения
disable triggers isolated to transaction only? Vick Khera <vivek@khera.org>
Re: disable triggers isolated to transaction only? Tom Lane <tgl@sss.pgh.pa.us>
Re: disable triggers isolated to transaction only? Ben Chobot <bench@silentmedia.com>
Re: disable triggers isolated to transaction only? "Greg Sabino Mullane" <greg@turnstep.com>
Re: disable triggers isolated to transaction only? Richard Huxton <dev@archonet.com> 
On Mar 2, 2010, at 9:48 AM, Vick Khera wrote:

>   I guess at worse I lock the table.

Before you go there, assuming you cannot just disable a trigger for a session, then depending on how many counters your insert trigger modifies, it might be better to simply undo the trigger's effects in the same transaction as the migration.
В списке pgsql-general по дате отправления
Предыдущее
От: Lee Hachadoorian
Дата:
Следующее
От: Scott Marlowe
Дата:
FAQ