| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Reject extnamespace if it's temporary or it's '$user'::regnamesp |
| Date: | 2026-11-09 14:22:03 |
| Message-ID: | E1xQQG3-000000003mJ-0EWC@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Reject extnamespace if it's temporary or it's '$user'::regnamespace.
Historical behavior was bizarre. 'CREATE EXTENSION tcn SCHEMA "$user"'
set extnamespace='$user'::regnamespace, but the extension's object
landed in the schema named after the bootstrap superuser if such a
schema existed, else in pg_temp. Many extension scripts failed, since
pg_temp is searched for only a subset of object types. In other
scenarios, a trusted-extension script located the wrong object and
executed arbitrary SQL of a non-superuser's choice. The prior commit's
locking additions could not cover this. Back-patch to v14 (all
supported versions).
Reported-by: Noah Misch <noah(at)leadboat(dot)com>
Reviewed-by: Greg Burd <greg(at)burd(dot)me>
Backpatch-through: 14
Security: CVE-2026-6467
Branch
------
REL_17_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/5c751533737eb08c97d6816e43039324e34bad42
Modified Files
--------------
src/backend/catalog/namespace.c | 13 +++++
src/backend/commands/extension.c | 36 ++++++++++---
.../test_extensions/expected/test_extensions.out | 60 +++++++++++++++++-----
.../test_extensions/sql/test_extensions.sql | 44 +++++++++++++---
4 files changed, 126 insertions(+), 27 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2026-11-09 14:22:04 | pgsql: Align REASSIGN OWNED caller-privilege checks with ALTER ... OWNE |
| Previous Message | Noah Misch | 2026-11-09 14:22:02 | pgsql: plperl: don't save and re-use temp context in return_next(). |