| From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
|---|---|
| To: | Louis Tian <louis(dot)tian(at)aquamonix(dot)com(dot)au> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Row Level Security Policy Name in Error Message |
| Date: | 2023-03-06 11:19:13 |
| Message-ID: | 03F98B8B-C263-4863-A3B6-675C518CB357@yesql.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On 6 Mar 2023, at 01:18, Louis Tian <louis(dot)tian(at)aquamonix(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vignesh C | 2023-03-06 13:13:51 | Re: Support logical replication of DDLs |
| Previous Message | wangw.fnst@fujitsu.com | 2023-03-06 10:16:59 | RE: Support logical replication of DDLs |