Message-ID: <65cb266f-cfb8-9195-5398-5dcc93bec13e@gmail.com>
Date: Mon, 8 Apr 2024 18:15:15 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: psql's FETCH_COUNT (cursor) is not being respected for CTEs
Content-Language: en-US
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Daniel Verite <daniel@manitou-mail.org>,
 Laurenz Albe <laurenz.albe@cybertec.at>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
 Robert Haas <robertmhaas@gmail.com>,
 Jakub Wartak <jakub.wartak@enterprisedb.com>
References: <10117fba-890b-46ac-9316-cae83108a6a6@manitou-mail.org>
 <0023bea5-79c0-476e-96c8-dad599cc3ad8@gmail.com>
 <3275590.1712588904@sss.pgh.pa.us>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <3275590.1712588904@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/65cb266f-cfb8-9195-5398-5dcc93bec13e%40gmail.com>
Precedence: bulk

08.04.2024 18:08, Tom Lane wrote:
> Alexander Lakhin <exclusion@gmail.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