From: | Marc Millas <marc(dot)millas(at)mokadb(dot)com> |
---|---|
To: | Erik Wienhold <ewie(at)ewie(dot)name> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: event trigger clarification |
Date: | 2023-08-31 11:54:42 |
Message-ID: | CADX_1abXYA1MP2KOh2FD1jC2D0YYd55yQB=WhkukYd35YWhyfA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks !
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Wed, Aug 30, 2023 at 6:18 PM Erik Wienhold <ewie(at)ewie(dot)name> wrote:
> > On 30/08/2023 17:12 CEST Marc Millas <marc(dot)millas(at)mokadb(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Arthur Bazin | 2023-08-31 15:08:00 | pg_dump/pg_restore and the magic of the search_path |
Previous Message | Marc Millas | 2023-08-31 11:54:21 | Re: event trigger clarification |