Re: Row Level Security Policy Name in Error Message - Mailing list pgsql-general

From Daniel Gustafsson
Subject Re: Row Level Security Policy Name in Error Message
Date
Msg-id 03F98B8B-C263-4863-A3B6-675C518CB357@yesql.se
Whole thread Raw
In response to Row Level Security Policy Name in Error Message  (Louis Tian <louis.tian@aquamonix.com.au>)
List pgsql-general
> On 6 Mar 2023, at 01:18, Louis Tian <louis.tian@aquamonix.com.au> wrote:

> Wondering whether there is a way to get the row-level security policy name in the error message when it's violated.
> I am only getting a more generic error message like this.
> ERROR:  new row violates row-level security policy for table "table_name"

If memory serves me right.  The name will be included in the error message in
case the operation violated a specific restrictive policy.  If no permissive
policy was found that would allow the operation then the error message will be
what you saw without a policy name (since none was explicitly violated).

--
Daniel Gustafsson




pgsql-general by date:

Previous
From: Louis Tian
Date:
Subject: Row Level Security Policy Name in Error Message
Next
From: Dominique Devienne
Date:
Subject: CREATE/DROP ROLE transactional? GRANT/REVOKE?