Skip trigger? - Mailing list pgsql-general

From wolfgang@alle-noten.de
Subject Skip trigger?
Date
Msg-id 20160430060836.12823.qmail@noten19
Whole thread Raw
Responses Re: Skip trigger?
Re: Skip trigger?
Re: Skip trigger?
List 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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: Why are data files stored in /var/lib
Next
From: Rafal Pietrak
Date:
Subject: Re: Why are data files stored in /var/lib