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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pgsql: Drop unnamed portal immediately after execution to completion
Date: 2025-11-10 21:13:24
Message-ID: CA+TgmoYFJyJNQw3RT7veO3M2BWRE9Aw4hprC5rOcawHZti-f8g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Wed, Nov 5, 2025 at 12:43 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
> Drop unnamed portal immediately after execution to completion

This patch doesn't look well-considered to me. One problem is that
it's a wire protocol change to fix a minor logging anomaly, which
seems disproportionate. Another problem is that the new portal-drop
behavior is conditional on whether XACT_FLAGS_NEEDIMMEDIATECOMMIT gets
set, which seems unprincipled. In addition to those points, I am not
entirely certain that the "here is no need for it beyond this point"
comment is correct. I mean, I think it will normally be true, but what
if the client wants to send a Describe message after-the-fact, or an
additional Execute message that will presumably return zero rows?

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2025-11-10 21:28:02 Re: pgsql: Drop unnamed portal immediately after execution to completion
Previous Message Heikki Linnakangas 2025-11-10 17:22:01 pgsql: Bump PG_CONTROL_VERSION for commit 3e0ae46d90

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2025-11-10 21:19:23 Re: vacuumdb: add --dry-run
Previous Message Jelte Fennema-Nio 2025-11-10 21:11:50 Re: RFC: adding pytest as a supported test framework