Make a SQL statement not run trigger

From: Jon Collette <jon(at)etelos(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Make a SQL statement not run trigger
Date: 2007-08-21 21:26:14
Message-ID: 46CB5876.80003@etelos.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rodrigo De León 2007-08-21 21:51:09 Re: Make a SQL statement not run trigger
Previous Message Michael Glaesemann 2007-08-21 21:16:35 Re: Join question