Acquire locks on views in AcquirePlannerLocks, too.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 65eb2d00c6c1bab29db9fa6575185a40d823fe9d
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2023-04-05T19:56:35Z
Releases: 16.0
Acquire locks on views in AcquirePlannerLocks, too.

Commit 47bb9db75 taught AcquireExecutorLocks to re-acquire locks
on views using data from their RTE_SUBQUERY replacements, but
it now seems like we should make AcquirePlannerLocks do the same.
In this way, if a view has been redefined, we will notice that
a bit earlier while checking validity of a cached plan and thereby
avoid some wasted work.

Report and patch by Amit Langote.

Discussion: https://postgr.es/m/CA+HiwqH0xZOQ+GQAdKeckY1R4NOeHdzhtfxkAMJLSchpapNk5w@mail.gmail.com

Files

PathChange+/−
src/backend/utils/cache/plancache.c modified +8 −0

Discussion