Running query without trigger?

From: hamann(dot)w(at)t-online(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: Running query without trigger?
Date: 2016-07-09 06:20:23
Message-ID: wolfgang-1160709082023.A0119336@linux-f7v9
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

a table is associated with a trigger for normal use.
An admin (someone with ALTER privilege) can disable tthe trigger, run some bulk update,
and then re-enable it. This means, however, that normal user activity has to be locked out.

There are two possible scenarios: the bulk update would not cause trigger activity at all,
because of the values and columns involved.
or - the bulk update is followed by another bulk transaction that is equivalent to trigger
invocations per row.
At least in the first case, running this particular query without triggering the trigger,
but normal activity still going on, would be really great
Is there a way to achieve this?

Regards
Wolfgang Hamann

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2016-07-09 06:54:06 Re: Running query without trigger?
Previous Message John R Pierce 2016-07-08 19:07:47 Re: Memory usage per session