Thread: Determine which Row Level Security policies were denied

From

José A. San Gil

Date:

05 April 2019, 19:11:32

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