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 <vivek@khera.org>)
Список pgsql-general
Дерево обсуждения 
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
inserttrigger modifies, it might be better to simply undo the trigger's effects in the same transaction as the
migration.

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

Предыдущее
От: Lee Hachadoorian
Дата:
Сообщение: Re: Array columns vs normalized table
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf