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

From: Mircea Cadariu <cadariu(dot)mircea(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Sami Imseih <samimseih(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pgsql: Drop unnamed portal immediately after execution to completion
Date: 2025-11-14 15:10:32
Message-ID: 0a666d28-9080-4239-90d6-f6345bb43468@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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

Attachment Content-Type Size
v1-0001-add-holdable-cursors-test.patch text/plain 1.4 KB

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2025-11-14 15:46:22 pgsql: doc: clarify that logical slots track transaction activity
Previous Message Andres Freund 2025-11-14 14:55:37 Re: pgsql: doc: remove verbiage about "receiving" data from rep. slots

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2025-11-14 15:20:41 Re: Uncommented GUC in postgresql.conf.sample
Previous Message Nathan Bossart 2025-11-14 15:02:36 Re: [Patch] Mention md5 is deprecated in postgresql.conf.sample