git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Recalculate search_path after ALTER ROLE.

author Jeff Davis <jdavis@postgresql.org>

Mon, 7 Aug 2023 22:13:24 +0000 (15:13 -0700)

committer Jeff Davis <jdavis@postgresql.org>

Wed, 9 Aug 2023 20:09:25 +0000 (13:09 -0700)

commit fa2e874946c5b9f23394358c131e987df7cc8ffb

tree 418135ed5b9a83ec551d0772b02c5d5f9e791f1c tree

parent c27f8621eedf744a7bc80e37dd2d3f0f559edf1b commit | diff

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 diff | blob | blame | history

src/test/isolation/expected/search-path-inval.out [new file with mode: 0644] blob

src/test/isolation/isolation_schedule diff | blob | blame | history

src/test/isolation/specs/search-path-inval.spec [new file with mode: 0644] blob

This is the main PostgreSQL git repository.

RSS Atom