Re: GUC for temporarily disabling event triggers

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, 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-25 07:19:35
Message-ID: 6E55AA0B-4B3C-483E-8F81-F138C69E5576@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 25 Sep 2023, at 01:35, Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> On Fri, Sep 22, 2023 at 05:29:01PM +0200, Daniel Gustafsson wrote:
>> 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.
>
> Okay.
>
> + be disabled by setting it to <literal>false</literal>. Setting the value
> + to <literal>true</literal> will not disable any event triggers, this
>
> This uses a double negation. Perhaps just "Setting this value to true
> allows all event triggers to run."

Fair enough, although I used "fire" instead of "run" which is consistent with
the event trigger documentation.

> 003_check_guc.pl has detected a failure because event_triggers is
> missing in postgresql.conf.sample while it is not marked with
> GUC_NOT_IN_SAMPLE anymore.
>
> Keeping the docs consistent with the sample file, I would suggest the
> attached on top of your v9.

Ah, yes.

The attached v10 has the above to fixes.

--
Daniel Gustafsson

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message torikoshia 2023-09-25 07:21:31 Re: RFC: Logging plan of the running query
Previous Message Daniel Gustafsson 2023-09-25 07:14:48 Re: Doc: vcregress .bat commands list lacks "taptest"