Recalculate search_path after ALTER ROLE.
authorJeff Davis <[email protected]>
Mon, 7 Aug 2023 22:13:24 +0000 (15:13 -0700)
committerJeff Davis <[email protected]>
Wed, 9 Aug 2023 20:09:25 +0000 (13:09 -0700)
commitfa2e874946c5b9f23394358c131e987df7cc8ffb
tree418135ed5b9a83ec551d0772b02c5d5f9e791f1c
parentc27f8621eedf744a7bc80e37dd2d3f0f559edf1b
Recalculate search_path after ALTER ROLE.

Renaming a role can affect the meaning of the special string $user, so
must cause search_path to be recalculated.

Discussion: https://postgr.es/m/186761d32c0255debbdf50b6310b581b9c973e6c[email protected]
Reviewed-by: Nathan Bossart, Michael Paquier
Backpatch-through: 11
src/backend/catalog/namespace.c
src/test/isolation/expected/search-path-inval.out [new file with mode: 0644]
src/test/isolation/isolation_schedule
src/test/isolation/specs/search-path-inval.spec [new file with mode: 0644]