Re: event trigger clarification

Поиск
Список
Период
Сортировка
От Marc Millas
Тема Re: event trigger clarification
Дата
Msg-id CADX_1abXYA1MP2KOh2FD1jC2D0YYd55yQB=WhkukYd35YWhyfA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: event trigger clarification  (Erik Wienhold <ewie@ewie.name>)
Список pgsql-general
Thanks !
Marc MILLAS
Senior Architect
+33607850334



On Wed, Aug 30, 2023 at 6:18 PM Erik Wienhold <ewie@ewie.name> wrote:
> On 30/08/2023 17:12 CEST Marc Millas <marc.millas@mokadb.com> wrote:
>
> the doc v15 states: " pg_event_trigger_ddl_commands returns a list of DDL
> commands executed by each user action, when invoked in a function attached
> to a ddl_command_end event trigger."
> When some ddl command is executed within a block, I would like to know if the
> event trigger fires when the line is executed or at commit time.

The event trigger fires just before[1]/after[2] executing a complete command.
So not at commit time.

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/tcop/utility.c;h=6b0a8652622b26887ea2ccd15ced3300e951c5dc#l1120
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/tcop/utility.c;h=6b0a8652622b26887ea2ccd15ced3300e951c5dc#l1923

--
Erik

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

Предыдущее
От: Marc Millas
Дата:
Сообщение: Re: event trigger clarification
Следующее
От: Arthur Bazin
Дата:
Сообщение: pg_dump/pg_restore and the magic of the search_path