Postgres Pro
Downloads
Home   >   mailing lists

Is it possible to disable insert/update/delete triggers for one transaction and not another? - Mailing list pgsql-general

From Karen Hill
Subject Is it possible to disable insert/update/delete triggers for one transaction and not another?
Date
Msg-id 1151521176.791619.274860@75g2000cwc.googlegroups.com
Whole thread Raw
Responses Re: Is it possible to disable insert/update/delete triggers for one transaction and not another?
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Brad Nicholson
Date:
Subject: Strange Behavior with Serializable Transcations
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Strange Behavior with Serializable Transcations