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

Edit

4233

Title

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