]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Recalculate search_path after ALTER ROLE.
authorJeff Davis <jdavis@postgresql.org>
Mon, 7 Aug 2023 22:12:49 +0000 (15:12 -0700)
committerJeff Davis <jdavis@postgresql.org>
Mon, 7 Aug 2023 22:12:49 +0000 (15:12 -0700)
commit9f3343e40df6fc92a3913eeb8e240e0f5c6a5cfc
tree957f5b4b395a59766f84226ef7db0812c5288620
parent83ed1f71c88ae948a5b6ec6d2a4802cc54470102
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
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]