pgsql: Include check on polpermissive relcache for policies - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Include check on polpermissive relcache for policies
Date
Msg-id E1wjo2p-000DeT-2q@gemulon.postgresql.org
Whole thread
List pgsql-committers
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

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/38d24d705ffda0d22628737cacc13034948594c0

Modified Files
--------------
src/backend/utils/cache/relcache.c | 2 ++
1 file changed, 2 insertions(+)


pgsql-committers by date:

Previous
From: Richard Guo
Date:
Subject: pgsql: Strip removed-relation references from PHVs in join clauses
Next
From: Michael Paquier
Date:
Subject: pgsql: Rework pgstat_write_statsfile() in combination with to_serialize