| From: | Erik Wienhold <ewie(at)ewie(dot)name> |
|---|---|
| To: | Marc Millas <marc(dot)millas(at)mokadb(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: event trigger clarification |
| Date: | 2023-08-30 16:18:51 |
| Message-ID: | 1721713174.17585.1693412331169@office.mailbox.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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 | David G. Johnston | 2023-08-30 18:44:49 | Re: event trigger clarification |
| Previous Message | Marc Millas | 2023-08-30 15:12:49 | event trigger clarification |