Re: event trigger clarification
| От | Erik Wienhold |
|---|---|
| Тема | Re: event trigger clarification |
| Дата | |
| Msg-id | 1721713174.17585.1693412331169@office.mailbox.org обсуждение исходный текст |
| Ответ на | event trigger clarification (Marc Millas <marc.millas@mokadb.com>) |
| Ответы |
Re: event trigger clarification
|
| Список | pgsql-general |
> 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 по дате отправления: