Re: Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows - Mailing list pgsql-hackers

On Wed, Jul 15, 2026 at 11:51 AM Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> This should also update the doc table "Policies Applied by Command
> Type" on the CREATE POLICY page. I'd suggest a new row for "UPDATE ...
> FOR PORTION OF" immediately after the "UPDATE" row, rather than trying
> to reuse the existing row with more conditions (and similarly for
> DELETE).
>
> Also, in the rowsecurity regression test, it would be a good idea to
> add test cases to the "Test policies applied by command type" section.
> Those tests are the confirmations that what that doc table says is
> true (the patch's tests aren't really checking that the SELECT policy
> is being applied, for example).

Thanks for taking a look! Here is a v4 with those additions.

Yours,

--
Paul              ~{:-)
pj@illuminatedcomputing.com