Re: GUC for temporarily disabling event triggers

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Mikhail Gribkov <youzhick(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: GUC for temporarily disabling event triggers
Date: 2023-09-22 15:29:01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> On 7 Sep 2023, at 21:02, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Thu, Sep 7, 2023 at 1:57 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>> I am a bit surprised by these two additions. Setting this GUC at
>> file-level can be useful, as is documenting it in the control file if
>> it provides some control of how a statement behaves, no?
> Yeah, I don't think these options should be used.


>> + Allow temporarily disabling execution of event triggers in order to
>> + troubleshoot and repair faulty event triggers. All event triggers will
>> + be disabled by setting it to <literal>true</literal>. Setting the value
>> + to <literal>false</literal> will not disable any event triggers, this
>> + is the default value. Only superusers and users with the appropriate
>> + <literal>SET</literal> privilege can change this setting.
>> Event triggers are disabled if setting this GUC to false, while true,
>> the default, allows event triggers. The values are reversed in this
>> description.
> Woops.


Since the main driver for this is to reduce the usage/need for single-user mode
I also reworded the patch slightly. Instead of phrasing this as an alternative
to single-user mode, I reversed it such that single-user mode is an alternative
to this GUC.

Daniel Gustafsson

Attachment Content-Type Size
v9-0001-Add-GUC-for-temporarily-disabling-event-triggers.patch application/octet-stream 9.1 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Anthonin Bonnefoy 2023-09-22 15:45:27 Re: POC: Extension for adding distributed tracing - pg_tracing
Previous Message Matthias van de Meent 2023-09-22 15:26:47 Re: GenBKI emits useless open;close for catalogs without rows