Determine which Row Level Security policies were denied

From: José A(dot) San Gil <jsangilve(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Determine which Row Level Security policies were denied
Date: 2019-04-05 16:11:32
Message-ID: CAGO36pXJ-yL0Dj56+=iKsCJKfSpFLS+fseHy+HZDmJ_qmqFDaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Nicholas Magann 2019-04-05 19:10:12 PostgreSQL in out School Project
Previous Message Peter Geoghegan 2019-04-05 16:04:36 Re: Pg analog to DBCC CCHECKDB?