Re: event trigger clarification - Mailing list pgsql-general

From Marc Millas
Subject Re: event trigger clarification
Date
Msg-id CADX_1aaRMt3GHTKoFdc2Tn40zKiwCvpHcLGk9+XrzVKu6==CtQ@mail.gmail.com
Whole thread Raw
In response to Re: event trigger clarification  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Thanks !
Marc MILLAS
Senior Architect
+33607850334



On Wed, Aug 30, 2023 at 8:44 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, August 30, 2023, Marc Millas <marc.millas@mokadb.com> wrote:
Hi,
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.


There is nothing there about event execution being able to be deferred.

David J.

 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG FDW query fails, works local, same credentials
Next
From: Marc Millas
Date:
Subject: Re: event trigger clarification