Re: Proposal to allow setting cursor options on Portals

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: Hannu Krosing <hannuk(at)google(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Subject: Re: Proposal to allow setting cursor options on Portals
Date: 2026-03-24 10:01:05
Message-ID: CADK3HH+JtK=-EDO0RzWjD5aV-Wa+DG991at=vmQa08KY6YY1Dg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 23 Mar 2026 at 21:59, Sami Imseih <samimseih(at)gmail(dot)com> wrote:

> Hi,
>
> One thing that just occurred to me is why must we limit
> the new protocol extension to holdable cursors?
>
> PQsendBindWithCursorOptions() will work with any cursor option,
> Maybe it should be called "_pq_.named_portal" or perhaps better
> "_pq_.cursor"?
>

Well there are currently ways to name a portal with V3 so named portal
doesn't make sense.

_pq_.cursor would be fine.

Dave

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Fan 2026-03-24 10:04:43 raise ERROR between EndPrepare and PostPrepare_Locks causes ROLLBACK 2pc PAINC
Previous Message Hayato Kuroda (Fujitsu) 2026-03-24 09:50:39 RE: [Proposal] Adding Log File Capability to pg_createsubscriber