Re: event trigger clarification

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
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:21
Message-ID: CADX_1aaRMt3GHTKoFdc2Tn40zKiwCvpHcLGk9+XrzVKu6==CtQ@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 8:44 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wednesday, August 30, 2023, Marc Millas <marc(dot)millas(at)mokadb(dot)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.
>>
>
> https://www.postgresql.org/docs/current/event-trigger-definition.html
>
> There is nothing there about event execution being able to be deferred.
>
> David J.
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2023-08-31 11:54:42 Re: event trigger clarification
Previous Message Tom Lane 2023-08-31 04:46:28 Re: PG FDW query fails, works local, same credentials