pgsql: Recalculate search_path after ALTER ROLE. - Mailing list pgsql-committers

From Jeff Davis
Subject pgsql: Recalculate search_path after ALTER ROLE.
Date
Msg-id E1qTpqn-001Fqd-Bl@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/43ba5105a8e0c28e893bd698f76211b5ea757145

Modified Files
--------------
src/backend/catalog/namespace.c                   |  6 +-
src/test/isolation/expected/search-path-inval.out | 97 +++++++++++++++++++++++
src/test/isolation/isolation_schedule             |  1 +
src/test/isolation/specs/search-path-inval.spec   | 59 ++++++++++++++
4 files changed, 162 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Jeff Davis
Date:
Subject: pgsql: Recalculate search_path after ALTER ROLE.
Next
From: Bruce Momjian
Date:
Subject: pgsql: doc: PG 16 relnotes, add Windows 10 huge pages fix