Add new RLS tests to test policies applied by command type.
Dean Rasheed <dean.a.rasheed@gmail.com>
Author:
Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2025-10-27T10:21:16Z
Releases:
19 (unreleased)
Add new RLS tests to test policies applied by command type. The existing RLS tests focus on the outcomes of various testing scenarios, rather than the exact policies applied. This sometimes makes it hard to see why a particular result occurred (e.g., which policy failed), or to construct a test that fails a particular policy check without an earlier check failing. These new tests issue NOTICE messages to show the actual policies applied for each command type, including the different paths through INSERT ... ON CONFLICT and MERGE, making it easier to verify the expected behaviour. Author: Dean Rasheed <dean.a.rasheed@gmail.com> Reviewed-by: Viktor Holmberg <v@viktorh.net> Reviewed-by: Jian He <jian.universality@gmail.com> Discussion: https://postgr.es/m/CAEZATCWqnfeChjK=n1V_dYZT4rt4mnq+ybf9c0qXDYTVMsy8pg@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/rowsecurity.out | modified | +259 −0 |
| src/test/regress/sql/rowsecurity.sql | modified | +139 −0 |
Discussion
- Docs and tests for RLS policies applied by command type 11 messages · 2025-03-27 → 2025-11-06