Re: Proposal to allow setting cursor options on Portals

From: Sami Imseih <samimseih(at)gmail(dot)com>
To: Dave Cramer <davecramer(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Proposal to allow setting cursor options on Portals
Date: 2025-12-08 19:43:10
Message-ID: CAA5RZ0ubsfUu7_mQjPyCmQHRHD9WuAZeyMSY0x=xQ38Q32AHGg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I did not look into this patch in detail yet, but I am +1 for being
able to create cursors at the protocol level.

I think this should be allowed for regular cursors as well. One
big use-case I see is allowing postgres_fdw to create and fetch
from cursors at the protocol level rather than SQL (DECLARE
CURSOR, FETCH, etc.)

--
Sami Imseih
Amazon Web Services (AWS)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Herrera 2025-12-08 19:45:07 Re: vacuumdb: add --dry-run
Previous Message Bryan Green 2025-12-08 19:41:45 Re: Let's add a test for NLS translation of PRI* macros