]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Include check on polpermissive relcache for policies REL_17_STABLE github/REL_17_STABLE
authorMichael Paquier <michael@paquier.xyz>
Wed, 15 Jul 2026 01:03:41 +0000 (10:03 +0900)
committerMichael Paquier <michael@paquier.xyz>
Wed, 15 Jul 2026 01:03:41 +0000 (10:03 +0900)
commit2d1ed2c1dd8e8eb4daa300f574331864a6c49688
tree935fef16536ac7ba341318ce9ce7d0c91c6cd831
parent885dc83380999842fb568af292529ea089c93d89
Include check on polpermissive relcache for policies

equalPolicy() is used in the relation cache to check if two policy
definitions are equivalent, but missed to check for polpermissive.

ALTER POLICY cannot switch a policy to be PERMISSIVE or RESTRICTIVE, so
this would need a dropped and then re-created policy, which would
trigger a relcache invalidation.  Anyway, there is no harm in being
consistent in the check, and if one decides to add an ALTER POLICY to
switch PERMISSIVE or RESTRICTIVE, we would be silently in trouble.

Author: Andreas Lind <andreaslindpetersen@gmail.com>
Reviewed-by: Laurenz Albe <laurenz.albe@cybertec.at>
Discussion: https://postgr.es/m/CAMxA3rv1CS6R7JR5ojz-3CmCEnZEFrqu+XXTnGbLRWrjJRH7sA@mail.gmail.com
Backpatch-through: 14
src/backend/utils/cache/relcache.c