| From: | Jeff Davis <jdavis(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Recalculate search_path after ALTER ROLE. |
| Date: | 2023-08-09 20:32:14 |
| Message-ID: | E1qTpqn-001Fqd-Bl@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2023-08-09 21:47:28 | pgsql: doc: PG 16 relnotes, add Windows 10 huge pages fix |
| Previous Message | Jeff Davis | 2023-08-09 20:32:07 | pgsql: Recalculate search_path after ALTER ROLE. |