Make a SQL statement not run trigger - Mailing list pgsql-sql

From Jon Collette
Subject Make a SQL statement not run trigger
Date
Msg-id 46CB5876.80003@etelos.com
Whole thread Raw
Responses Re: Make a SQL statement not run trigger  ("Rodrigo De León" <rdeleonp@gmail.com>)
Re: Make a SQL statement not run trigger  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Make a SQL statement not run trigger  (Thomas Kellerer <spam_eater@gmx.net>)
List 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


pgsql-sql by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Join question
Next
From: "Rodrigo De León"
Date:
Subject: Re: Make a SQL statement not run trigger