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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Alexander Lakhin <exclusion@gmail.com>

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>

Date: 2024-04-08T15:08:24Z

Lists: pgsql-hackers

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 ...

			regards, tom lane

Commits

Further review for re-implementation of psql's FETCH_COUNT feature.
- c21d4c416ad6 17.0 landed
Re-implement psql's FETCH_COUNT feature atop libpq's chunked mode.
- 90f5178211cd 17.0 landed
Support retrieval of results in chunks with libpq.
- 4643a2b265e9 17.0 landed
Attempt to fix newly added Memoize regression test
- a3a836fb5e51 17.0 cited