Thanks ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com
On Wed, Aug 30, 2023 at 6:18 PM Erik Wienhold <e...@ewie.name> wrote: > > On 30/08/2023 17:12 CEST Marc Millas <marc.mil...@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 >
