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

Daniel Verite <daniel@manitou-mail.org>

View thread View on postgr.es

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

To: "PostgreSQL Hackers" <pgsql-hackers@postgresql.org>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Jakub Wartak <jakub.wartak@enterprisedb.com>

Date: 2023-03-01T10:41:13Z

Lists: pgsql-hackers

Attachments

psql-fetchcount-single-row-mode-v2.diff (text/x-patch) patch v2

  I wrote:

> Here's a POC patch implementing row-by-row fetching.

PFA an updated patch.


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