Skip trigger?

From: wolfgang(at)alle-noten(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Skip trigger?
Date: 2016-04-30 06:08:36
Message-ID: 20160430060836.12823.qmail@noten19
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-04-30 07:59:01 Re: Why are data files stored in /var/lib
Previous Message Charles Clavadetscher 2016-04-30 04:13:18 Re: Why are data files stored in /var/lib