Re: pgsql: Drop unnamed portal immediately after execution to completion

Mircea Cadariu <cadariu.mircea@gmail.com>

From: Mircea Cadariu <cadariu.mircea@gmail.com>

To: Michael Paquier <michael@paquier.xyz>

Cc: Sami Imseih <samimseih@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, Frédéric Yhuel <frederic.yhuel@dalibo.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-11-14T15:10:32Z

Lists: pgsql-hackers

Attachments

v1-0001-add-holdable-cursors-test.patch (text/plain)

Hi Michael,

I think I found a gap in the tests we added previously for documenting 
the current behaviour. See attached patch for your consideration.

What's interesting about the holdable cursors scenario is that as far as 
I can tell the temp files are cleaned up during PersistHoldablePortal 
instead of PortalDrop.


Kind regards,

Mircea Cadariu