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_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/5b2bd1dc1232937762b75c73ee5aea275857a58a 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(+)
