Is it possible to disable insert/update/delete triggers for one transaction and not another?

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it possible to disable insert/update/delete triggers for one transaction and not another?
Date: 2006-06-28 18:59:36
Message-ID: 1151521176.791619.274860@75g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have an insert/update/delete trigger on all my tables which add data
to a log table.

I would like to be able to disable them when the tables are called from
one stored proceedure I have. Yet I would still like those triggers to
fire on any other operation that is happening concurrently. Is this
even possible?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-06-28 19:20:49 Re: Strange Behavior with Serializable Transcations
Previous Message Brad Nicholson 2006-06-28 18:48:01 Strange Behavior with Serializable Transcations