Skip trigger?

Поиск
Список
Период
Сортировка
От wolfgang@alle-noten.de
Тема Skip trigger?
Дата
Msg-id 20160430060836.12823.qmail@noten19
обсуждение исходный текст
Ответы Re: Skip trigger?  (Peter Devoy <peter@3xe.co.uk>)
Re: Skip trigger?  (Manuel Gómez <targen@gmail.com>)
Re: Skip trigger?  (Stephen Cook <sclists@gmail.com>)
Список pgsql-general
Hi,

I have a table with a row update trigger that is quite slow.
The trigger finction basically sets some bits in a "changed" column
depending on which values really changed.
For some bulk updates it can be determined in advance that the
trigger function will not have any effect.
Is there any way to run an update query and specify that it should not
activate the trigger.
I know that I can disable the trigger and reenable it later;
however other concurrent updates mights need it

Best regards
Wolfgang Hamann


В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Why are data files stored in /var/lib
Следующее
От: Rafal Pietrak
Дата:
Сообщение: Re: Why are data files stored in /var/lib