Good Idea. However some of my triggers use the DELETE action as well.
So I can't use this method.
Thomas Kellerer wrote:
Jon Collette wrote on 21.08.2007 23:26:
Is it possible to run an insert,update, or delete and have it not
launch a trigger like it normally would?
For example could I set a value
DONOTRUN = True;
insert into contacts ....
Where the trigger on contacts would call a function that would have
an IF statment for that DONOTRUN value?
Or is there just a global variable I could set to disable triggers
and then reset it? And would that be a per connection variable?
What we have done once, was to include a column in the table for this
purpose. If a special value for the column was provided during UPDATE
or INSERT, the trigger would immediately terminate, not doing any
work. Thus the trigger still "fires" every time, but simply won't do
nothing. Not very elegant, but worked for our environment.
Thomas
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
