pgsql: Close portals at end of trigger functions with transition tables

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Close portals at end of trigger functions with transition tables
Date: 2026-11-09 14:21:51
Message-ID: E1xQQFr-000000003Mr-0wlN@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Close portals at end of trigger functions with transition tables.

The query environment needed for portals over transition tables for
triggers lasts only as long as the SPI connection, so the portals must
be closed. If not closed within the function, SPI_finish()
force-closes them.

Reported-by: Peter Geoghegan <pg(at)bowt(dot)ie>
Reviewed-by: Amit Langote <amitlangote09(at)gmail(dot)com>
Backpatch-through: 14
Security: CVE-2026-120143

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/7a910b4e1586fa3b198fb6e5806c7ea842012179
Author: Jeff Davis <jdavis(at)postgresql(dot)org>

Modified Files
--------------
doc/src/sgml/spi.sgml | 9 +++++++++
src/backend/executor/spi.c | 14 ++++++++++++++
src/backend/utils/mmgr/portalmem.c | 34 ++++++++++++++++++++++++++++++++++
src/include/utils/portal.h | 1 +
4 files changed, 58 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Noah Misch 2026-11-09 14:21:52 pgsql: Avoid use-after-free hazards in re-entrant use of pltcl.
Previous Message Noah Misch 2026-11-09 14:21:50 pgsql: Teach equalRowTypes() to safely handle dropped columns.