Skip site navigation (1) Skip section navigation (2)

Enable/Disable Trigger per single transaction

From: "Derrick Betts" <list(at)blueaxis(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Enable/Disable Trigger per single transaction
Date: 2007-01-27 16:48:37
Message-ID: 03f301c74233$00562780$0202a8c0@main (view raw or flat)
Thread:
Lists: pgsql-novice
Assuming we have well over 1000 users accessing the database through a web 
application.
We have a row-level trigger set up on table "alpha" that gets executed after 
updates.

I was wondering if there is a way to temporarily disable a trigger on table 
"alpha" for a single user, even though there may be 999 other users sending 
transactions to the database that need the trigger to remain in place?  For 
example, I only want the trigger disabled for one single transaction (using 
commands inside that transaction) while the trigger still gets fired 
properly for the other 999 transactions that hit the database 
simultaneously.

Is this possible at present?

Thank you for your insights,
Derrick 



In response to

Responses

pgsql-novice by date

Next:From: Duncan GarlandDate: 2007-01-27 17:15:45
Subject: Re: Enable/Disable Trigger per single transaction
Previous:From: Oisin GlynnDate: 2007-01-26 23:25:06
Subject: Re: [NOVICE] Windows 2K Installation difficulties...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group