Re: disable triggers isolated to transaction only? - Mailing list pgsql-general

From Ben Chobot
Subject Re: disable triggers isolated to transaction only?
Date
Msg-id B06047F7-57AD-4D5D-8C96-B55CBC6D7C92@silentmedia.com
Whole thread Raw
In response to disable triggers isolated to transaction only?  (Vick Khera <vivek@khera.org>)
List 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 by date:

Previous
From: Lee Hachadoorian
Date:
Subject: Re: Array columns vs normalized table
Next
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf