pgsql: Reject extnamespace if it's temporary or it's '$user'::regnamesp

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(-)

Browse pgsql-committers by date

  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().