Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs

From: Alexander Lakhin <exclusion(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Daniel Verite <daniel(at)manitou-mail(dot)org>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>
Subject: Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs
Date: 2024-04-08 15:15:15
Message-ID: 65cb266f-cfb8-9195-5398-5dcc93bec13e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

08.04.2024 18:08, Tom Lane wrote:
> Alexander Lakhin <exclusion(at)gmail(dot)com> writes:
>> Now that ExecQueryUsingCursor() is gone, it's not clear, what does
>> the following comment mean:?
>>    * We must turn off gexec_flag to avoid infinite recursion.  Note that
>>    * this allows ExecQueryUsingCursor to be applied to the individual query
>>    * results.
> Hmm, the point about recursion is still valid isn't it? I agree the
> reference to ExecQueryUsingCursor is obsolete, but I think we need to
> reconstruct what this comment is actually talking about. It's
> certainly pretty obscure ...

Sorry, I wasn't clear enough, I meant to remove only that reference, not
the quoted comment altogether.

Best regards,
Alexander

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2024-04-08 15:21:41 Re: PostgreSQL 17 Release Management Team & Feature Freeze
Previous Message Tom Lane 2024-04-08 15:08:24 Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs