Postgres Pro
Downloads
Home   >   mailing lists

Determine which Row Level Security policies were denied - Mailing list pgsql-general

From José A. San Gil
Subject Determine which Row Level Security policies were denied
Date
Msg-id CAGO36pXJ-yL0Dj56+=iKsCJKfSpFLS+fseHy+HZDmJ_qmqFDaQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
Hi!

Is it possible to determine which RLS policies failed on INSERT OR UPDATE? For instance, this is the error returned when inserting a new record:

**ERROR: new row violates row-level security policy for table "my_table"**

Is it possible to obtain the name of the policy(ies) that denied the operation?

Thanks
--
José A. San Gil M 

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Pg analog to DBCC CCHECKDB?
Next
From: Nicholas Magann
Date:
Subject: PostgreSQL in out School Project