Re: GUC for temporarily disabling event triggers

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: GUC for temporarily disabling event triggers
Дата
Msg-id E241BCDE-A8BA-483A-B368-F758CB8E0602@yesql.se
обсуждение исходный текст
Ответ на Re: GUC for temporarily disabling event triggers  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: GUC for temporarily disabling event triggers  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
> On 2 Apr 2023, at 21:48, Justin Pryzby <pryzby@telsasoft.com> wrote:

> +                       gettext_noop("Disable event triggers for the duration of the session."),
>
> Why does is it say "for the duration of the session" ?
>
> It's possible to disable ignoring, and within the same session.
> GUCs are typically "for the duration of the session" .. but they don't
> say so (and don't need to).
>
> +                       elog(ERROR, "unsupport event trigger: %d", event);
>
> typo: unsupported
>
> +        Allows to temporarily disable event triggers from executing in order
>
> => Allow temporarily disabling execution of event triggers ..
>
> +        to troubleshoot and repair faulty event triggers. The value matches
> +        the type of event trigger to be ignored:
> +        <literal>ddl_command_start</literal>, <literal>ddl_command_end</literal>,
> +        <literal>table_rewrite</literal> and <literal>sql_drop</literal>.
> +        Additionally, all event triggers can be disabled by setting it to
> +        <literal>all</literal>. Setting the value to <literal>none</literal>
> +        will ensure that all event triggers are enabled, this is the default
>
> It doesn't technically "ensure that they're enabled", since they can be
> disabled by ALTER.  Better to say that it "doesn't disable any even triggers".

All comments above addressed in the attached v5, thanks for review!

--
Daniel Gustafsson



Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sketch of a fix for that truncation data corruption issue
Следующее
От: Robert Haas
Дата:
Сообщение: Re: GUC for temporarily disabling event triggers