Horton

Recalculate search_path after ALTER ROLE.

Jeff Davis <jdavis@postgresql.org>

View on postgr.es
Commit: 0d56c32c8e724f96f4aa5b15645d427f6e2ddf21
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2023-08-09T20:09:01Z
Releases: 16.0 
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.camel@j-davis.com
Reviewed-by: Nathan Bossart, Michael Paquier
Backpatch-through: 11

Files

PathChange+/−
src/backend/catalog/namespace.c modified +5 −1
src/test/isolation/expected/search-path-inval.out added +97 −0
src/test/isolation/isolation_schedule modified +1 −0
src/test/isolation/specs/search-path-inval.spec added +59 −0

Discussion