Re: Support named (destination) portals in extended proto for psql meta commands. - Mailing list pgsql-hackers

From Jelte Fennema-Nio
Subject Re: Support named (destination) portals in extended proto for psql meta commands.
Date
Msg-id CAGECzQRG35g_6MuNgTq+2P+NTpupM8kq9zvxR3L4M2Ovhx1hQw@mail.gmail.com
Whole thread Raw
In response to Support named (destination) portals in extended proto for psql meta commands.  (Kirill Reshke <reshkekirill@gmail.com>)
List pgsql-hackers
On Sat, 13 Dec 2025 at 09:56, Kirill Reshke <reshkekirill@gmail.com> wrote:
> And I faced a problem, that there is no way to test
> extended query bind commands for non-empty destination portal. So, I
> propose to add a psql meta command just for that purpose. Something
> like \bind_cursor CURSOR_NAME STMT_NAME [params..]

Probably call it bind_portal though. So far we've aligned the meta
command names with the protocol/libpq names (e.g. \parse instead of
\prepare)

> So, sending non-empty portal names was never supported in libpq?
> It makes me think there was a good reason for that. Can somebody
> please clarify on that?

No good reason, just no-one spent the time to implement it. libpq
hasn't implemented most of the somewhat more exotic parts of the
protocol. So yeah, addition is definitely welcome.



pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: Remaining dependency on setlocale()
Next
From: Alexander Lakhin
Date:
Subject: Re: Making jsonb_agg() faster