Re: disable triggers isolated to transaction only?

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Vick Khera <vivek(at)khera(dot)org>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: disable triggers isolated to transaction only?
Date: 2010-03-02 18:47:05
Message-ID: B06047F7-57AD-4D5D-8C96-B55CBC6D7C92@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 insert trigger modifies, it might be better to simply undo the trigger's effects in the same transaction as the migration.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-03-02 19:20:10 Re: The OS Command for pg_hotbackup -- Use lvmsnapshot instead of tar cvzf
Previous Message Lee Hachadoorian 2010-03-02 18:42:34 Re: Array columns vs normalized table