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: 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-13 12:26:19
Message-ID: e0ab1ea2-7084-44c5-b6aa-f01db7be7792@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On 13/11/2025 06:27, Michael Paquier wrote:

> This is new, attaching the information to a Vfd in fd.c. Not sure
> that adding this information to this structure is a good concept.
> This layer of the code has no idea of query strings currently, so that
> feels a bit like a layer violation.

Thanks for having a look! FWIW I found a way for Plan C to work without
including tcoprot into fd, see attached.

There's a new field in that structure indeed, but maybe not that far
fetched, it's the query that triggered the creation of the file.

Kind regards,

Mircea Cadariu

Attachment Content-Type Size
v2-0001-show-temp-file-creating-query.patch text/plain 7.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2025-11-13 12:32:27 Re: Few untranslated error messages in OAuth
Previous Message Mihail Nikalayeu 2025-11-13 12:22:38 Re: [BUG?] check_exclusion_or_unique_constraint false negative

Browse pgsql-committers by date

  From Date Subject
Previous Message Dean Rasheed 2025-11-13 12:08:04 pgsql: doc: Improve description of RLS policies applied by command type