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

Daniel Verite <daniel@manitou-mail.org>

From: "Daniel Verite" <daniel@manitou-mail.org>

To: "vignesh C" <vignesh21@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Jakub Wartak <jakub.wartak@enterprisedb.com>

Date: 2024-01-30T14:29:37Z

Lists: pgsql-hackers

Attachments

v6-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch (text/plain) patch v6-0001
v6-0002-Reimplement-FETCH_COUNT-with-the-chunked-mode-in-.patch (text/plain) patch v6-0002

	vignesh C wrote:

> patching file src/interfaces/libpq/exports.txt
> Hunk #1 FAILED at 191.
> 1 out of 1 hunk FAILED -- saving rejects to file
> src/interfaces/libpq/exports.txt.rej
> 
> Please post an updated version for the same.

PFA a rebased version.


Best regards,
-- 
Daniel Vérité
https://postgresql.verite.pro/
Twitter: @DanielVerite

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