Re: RLS without leakproof restrictions?

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 t

Re: Event Triggers unable to capture the DDL script executed

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

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 statem

Re: Event Triggers unable to capture the DDL script executed

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 & Regards,