Re: Make a SQL statement not run trigger

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