From: | Neethu P <neeth_3(at)hotmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "n(dot)kobzarev(at)aeronavigator(dot)ru" <n(dot)kobzarev(at)aeronavigator(dot)ru>, 'pgsql-general' <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Event Triggers unable to capture the DDL script executed |
Date: | 2023-02-23 11:33:13 |
Message-ID: | MWHPR12MB1792A8AC190235F0FBB8641BD1AB9@MWHPR12MB1792.namprd12.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Laurenz. Is there any documentaion example to use the pg_ddl_command to capture the actual ddl statement (for event triggers in C)?
Regards,
Neethu
________________________________
From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Sent: Thursday, February 23, 2023 4:20 PM
To: Neethu P <neeth_3(at)hotmail(dot)com>; n(dot)kobzarev(at)aeronavigator(dot)ru <n(dot)kobzarev(at)aeronavigator(dot)ru>; 'pgsql-general' <pgsql-general(at)postgresql(dot)org>
Subject: Re: Event Triggers unable to capture the DDL script executed
On Thu, 2023-02-23 at 04:10 +0000, Neethu P wrote:
> Actually, current_query() may not help us in our case, as we won't be able
> to capture the ddl statement completely in case if it's in multiple lines.
Multiple lines should not be a problem. The problems I see are
- you won't catch DDL statements issued in a function with that, since you
only see the top-level statement
- if you have the DDL statement as string, you need to parse it, which is
non-trivial
> Can you please help me with the event trigger in C? & also how can we
> integrate it with our current postgresql DB?
In an e-mail, I cannot do much beyond pointing you to the documentation:
https://www.postgresql.org/docs/current/event-trigger-interface.html
There is also a simple example:
https://www.postgresql.org/docs/current/event-trigger-example.html
Getting used to reading and writing PostgreSQL server code takes a while.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Ajin Cherian | 2023-02-23 11:42:07 | Re: Support logical replication of DDLs |
Previous Message | Laurenz Albe | 2023-02-23 10:50:36 | Re: Event Triggers unable to capture the DDL script executed |