Make a SQL statement not run trigger

Поиск
Список
Период
Сортировка
От Jon Collette
Тема Make a SQL statement not run trigger
Дата
Msg-id 46CB5876.80003@etelos.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Join question
Следующее
От: "Rodrigo De León"
Дата:
Сообщение: Re: Make a SQL statement not run trigger