Re: RLS without leakproof restrictions?

2023-02-23 Thread Stephen Frost
Greetings, * Tom Dunstan (pg...@tomd.cc) wrote: > I'm currently researching different strategies for retrofitting some > multi-tenant functionality into our existing Postgres-backed application. > One of the options is using RLS policies to do row filtering. This is quite > attractive as I dread

Re: Event Triggers unable to capture the DDL script executed

2023-02-23 Thread Neethu P
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 Sent: Thursday, February 23, 2023 4:20 PM To: Neethu P ; n.kobza...@aeronavigator.ru ;

Re: Event Triggers unable to capture the DDL script executed

2023-02-23 Thread Laurenz Albe
On Thu, 2023-02-23 at 04:10 +, 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

Re: Event Triggers unable to capture the DDL script executed

2023-02-23 Thread Neethu P
Hi Laurenz, 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. Can you please help me with the event trigger in C? & also how can we integrate it with our current postgresql DB? Thanks &