Use libpq single row mode for FETCH_COUNT when a cursor cannot be used

Edit
ID 4233
Title Use libpq single row mode for FETCH_COUNT when a cursor cannot be used
Topic Clients
Created 2023-03-01 10:34:13
Last modified 2024-04-07 00:45:46 (6 months ago)
Latest email 2024-04-08 20:04:50 (6 months ago)
Status
2024-03: Committed
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
Target version
Authors Daniel Vérité (danielverite)
Reviewers Tom Lane (tgl), Laurenz Albe (laurenz)Become reviewer
Committer Tom Lane (tgl)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4233
git checkout commitfest/cf/4233
Emails
psql's FETCH_COUNT (cursor) is not being respected for CTEs
First at 2023-01-04 12:10:20 by Jakub Wartak <jakub.wartak at enterprisedb.com>
Latest at 2024-04-08 20:04:50 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v7-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch) at 2024-04-01 17:52:42 from "Daniel Verite" <daniel at manitou-mail.org>
    Attachment (v7-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch) at 2024-04-01 17:52:42 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)
    Attachment (v6-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch) at 2024-01-30 14:29:37 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)
    Attachment (v5-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch) at 2024-01-02 14:58:14 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)
    Attachment (v4-0001-Implement-retrieval-of-results-in-chunks-with-lib.patch) at 2023-11-20 19:13:35 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)
    Attachment (psql-fetchcount-single-row-mode-v3.diff) at 2023-07-07 17:42:57 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)
    Attachment (psql-fetchcount-single-row-mode-v2.diff) at 2023-03-01 10:41:13 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)
    Attachment (psql-fetchcount-single-row-mode.diff) at 2023-01-12 12:27:32 from "Daniel Verite" <daniel at manitou-mail.org> (Patch: Yes)
    Attachment (0001-psql-warn-about-CTE-queries-to-be-executed-without-u.patch) at 2023-01-10 12:23:19 from Jakub Wartak <jakub.wartak at enterprisedb.com> (Patch: Yes)
    Attachment (0001-psql-allow-CTE-queries-to-be-executed-also-using-cur.patch) at 2023-01-04 12:10:20 from Jakub Wartak <jakub.wartak at enterprisedb.com> (Patch: Yes)
History
When Who What
2024-04-07 00:45:46 Tom Lane (tgl) Closed in commitfest 2024-03 with status: Committed
2024-04-07 00:45:46 Tom Lane (tgl) Changed committer to tgl
2024-04-06 18:31:11 Tom Lane (tgl) Added tgl as reviewer
2024-04-01 17:58:46 Daniel Vérité (danielverite) New status: Needs review
2024-03-29 13:09:54 Laurenz Albe (laurenz) New status: Waiting on Author
2024-03-29 13:09:49 Laurenz Albe (laurenz) Added laurenz as reviewer
2024-02-01 16:39:15 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-31 13:15:18 Daniel Vérité (danielverite) New status: Needs review
2024-01-30 10:50:04 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2023-12-04 08:56:40 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:33:55 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-01 20:21:37 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-07 18:09:20 Daniel Vérité (danielverite) New status: Needs review
2023-04-09 01:33:27 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-04-02 18:13:07 Tom Lane (tgl) New status: Waiting on Author
2023-03-01 10:42:20 Daniel Vérité (danielverite) Changed name to Use libpq single row mode for FETCH_COUNT when a cursor cannot be used
2023-03-01 10:34:41 Daniel Vérité (danielverite) Changed authors to Daniel Vérité (danielverite)
2023-03-01 10:34:13 Daniel Vérité (danielverite) Attached mail thread CAKZiRmxsVTkO928CM+-ADvsMyePmU3L9DQCa9NwqjvLPcEe5QA@mail.gmail.com
2023-03-01 10:34:13 Daniel Vérité (danielverite) Created patch record
Edit