> Is this the right way to do these checks? I'll try to look into it a
> bit more today, but does this cause problems when an UPDATE *doesn't*
> create leftovers?

I did some extra testing but couldn't find any problems. I looked at
INSERT policies when FOR PORTION OF exactly matches a row's bounds (so
the row is updated but there are no leftovers), and also INSERT
policies that include sublinks.

> We should update the documentation as well. I think it should point
> out the contrast between ACLs and RLS here.

Here is a v2 with a couple lines of documentation added.

Yours,

-- 
Paul              ~{:-)
[email protected]

Attachment: v2-0001-Fix-RLS-checks-for-FOR-PORTION-OF-leftover-rows.patch
Description: Binary data

Reply via email to