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 <[email protected]>
Reviewed-by: Amit Langote <[email protected]>
Backpatch-through: 14
Security: CVE-2026-120143

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9ee5586a2a0692f28f657fac180db3be82bd6aed
Author: Jeff Davis <[email protected]>

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

Reply via email to