From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | alpic(at)benchmarkconsulting(dot)com |
Subject: | BUG #18521: RLS should report when non-select operation is refused |
Date: | 2024-06-24 18:10:29 |
Message-ID: | 18521-8c6cf61397cdc7ea@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18521
Logged by: Alain Picard
Email address: alpic(at)benchmarkconsulting(dot)com
PostgreSQL version: 15.1
Operating system: Ubuntu
Description:
When dealing with RLS policies it is possible to have an update operation
for example that is refused and to received a success status.
Even when looking at logs, nothing clearly indicates that the operation was
refused. In the case of debugging, we should also be able to at least be
able to know which policy triggered the refusal.
I would even expect to have a debug mode where it is possible to trace all
of the RLS policies that are invoked, in which order and to easily identify
if and where the operation is denied.
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2024-06-24 18:16:38 | BUG #18522: Wrong results with Merge Right Anti Join, inconsistent with Merge Anti Join |
Previous Message | Tom Lane | 2024-06-24 16:06:29 | Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943 |