Re: event trigger clarification - Mailing list pgsql-general

From David G. Johnston
Subject Re: event trigger clarification
Date
Msg-id CAKFQuwasdmAKC3J=gGf5LSZ7oh8KbCu_XGWKqeh0O=p9a2X_UQ@mail.gmail.com
Whole thread Raw
In response to event trigger clarification  (Marc Millas <marc.millas@mokadb.com>)
Responses Re: event trigger clarification  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
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: Erik Wienhold
Date:
Subject: Re: event trigger clarification
Next
From: Dimitrios Apostolou
Date:
Subject: Partitionwise JOIN scanning all partitions, even unneeded ones