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 (7 months, 2 weeks ago)

Latest email 2024-04-08 20:04:50 (7 months, 1 week 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