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