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
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Clients
Tags
Created 2023-03-01 10:34:13
Last modified 2024-04-07 00:45:46 (1 year ago)
Latest email 2024-04-08 20:04:50 (1 year ago)
Status
2024-03 (2024-03-01 – 2024-04-08): Committed
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
2023-11 (2023-11-01 – 2023-12-04): Moved to different CF
2023-09 (2023-09-01 – 2023-09-30): Moved to different CF
2023-07 (2023-07-01 – 2023-07-31): Moved to different CF
2023-03 (2023-03-01 – 2023-04-08): Moved to different CF
Target version
Authors Daniel Vérité (danielverite)
Reviewers Tom Lane (tgl), Laurenz Albe (laurenz)Become reviewer
Committer Tom Lane (tgl)
Links
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