Re: How to get a notification

2025-02-07 Thread Adrian Klaver
On 2/7/25 11:43, Igor Korot wrote: Hi, Adrian, It is not about the interface it is about, from link above: "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."

Re: How to get a notification

2025-02-07 Thread Igor Korot
Hi, Adrian, On Fri, Feb 7, 2025, 1:13 PM Adrian Klaver wrote: > > > On 2/7/25 11:02 AM, Igor Korot wrote: > > Hi, Adrian, > > > > On Fri, Feb 7, 2025 at 11:07 AM Adrian Klaver > wrote: > >> > >> On 2/5/25 23:21, Igor Korot wrote: > >>> Hi, ALL, > >>> In my code I'm running following: > >>> >

Re: How to get a notification

2025-02-07 Thread Adrian Klaver
On 2/7/25 11:02 AM, Igor Korot wrote: Hi, Adrian, On Fri, Feb 7, 2025 at 11:07 AM Adrian Klaver wrote: On 2/5/25 23:21, Igor Korot wrote: Hi, ALL, In my code I'm running following: queries.push_back( L"CREATE FUNCTION __watch_schema_changes() RETURNS event_trigger LANGUAGE

Re: How to get a notification

2025-02-07 Thread Igor Korot
Hi, Adrian, On Fri, Feb 7, 2025 at 11:07 AM Adrian Klaver wrote: > > On 2/5/25 23:21, Igor Korot wrote: > > Hi, ALL, > > In my code I'm running following: > > > > queries.push_back( L"CREATE FUNCTION > > __watch_schema_changes() RETURNS event_trigger LANGUAGE plpgsql AS $$ > > BEGIN

Re: How to get a notification

2025-02-07 Thread Adrian Klaver
On 2/5/25 23:21, Igor Korot wrote: Hi, ALL, In my code I'm running following: queries.push_back( L"CREATE FUNCTION __watch_schema_changes() RETURNS event_trigger LANGUAGE plpgsql AS $$ BEGIN NOTIFY tg_tag; END; $$;" ); queries.push_back( L"CREATE EVENT TRIGGER schema_ch

How to get a notification

2025-02-05 Thread Igor Korot
Hi, ALL, In my code I'm running following: queries.push_back( L"CREATE FUNCTION __watch_schema_changes() RETURNS event_trigger LANGUAGE plpgsql AS $$ BEGIN NOTIFY tg_tag; END; $$;" ); queries.push_back( L"CREATE EVENT TRIGGER schema_change_notify ON ddl_command_end WHEN TAG