Fix a bug where ALTER SYSTEM SET with empty strings for GUC_LIST_QUOTE parameters (like shared_preload_libraries) results in malformed configuration entries that cause server crashes on restart.

Edit
ID 6026
Title Fix a bug where ALTER SYSTEM SET with empty strings for GUC_LIST_QUOTE parameters (like shared_preload_libraries) results in malformed configuration entries that cause server crashes on restart.
CI (CFBot) Summary
Stats (from CFBot) Patch version: v6, Patch count: 1, First patch: +126−16, All patches: +126−16
Topic Bug Fixes
Tags Bugfix
Created 2025-09-02 06:07:47
Last modified 2025-11-04 17:38:29 (2 weeks ago)
Latest email 2025-11-04 18:59:55 (2 weeks ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Committed
Target version stable
Authors Andrew Klychkov (andreiklychkov)
Reviewers Tom Lane (tgl), Jim Jones (jimus)Become reviewer
Committer Tom Lane (tgl)
Links
Emails
[PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters
First at 2025-08-28 09:29:03 by Andrei Klychkov <andrew.a.klychkov at gmail.com>
Latest at 2025-11-04 18:59:55 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v6-0001-Allow-SET-list_guc-TO-NULL-to-specify-setting-the.patch) at 2025-11-01 20:11:46 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v6-0001-Allow-SET-list_guc-TO-NULL-to-specify-setting-the.patch) at 2025-11-01 20:11:46 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v5-allow-SET-to-an-empty-list.patch) at 2025-09-05 21:06:17 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v4-allow-SET-to-an-empty-list.patch) at 2025-09-05 09:08:15 from Andrei Klychkov <andrew.a.klychkov at gmail.com> (Patch: Yes)
    Attachment (v3-allow-SET-to-an-empty-list.patch) at 2025-09-04 21:52:49 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2_README_fix.md) at 2025-09-03 09:59:26 from Andrei Klychkov <andrew.a.klychkov at gmail.com> (Patch: No)
    Attachment (README_fix.md) at 2025-08-28 09:29:03 from Andrei Klychkov <andrew.a.klychkov at gmail.com> (Patch: No)
History
When Who What
2025-11-04 17:38:29 Tom Lane (tgl) Closed in commitfest PG19-3 with status: Committed
2025-11-04 17:38:29 Tom Lane (tgl) Changed committer to tgl
2025-11-03 09:37:11 Jim Jones (jimus) Added jimus as reviewer
2025-11-01 17:39:10 Tom Lane (tgl) Added tgl as reviewer
2025-09-05 10:37:44 Jim Jones (jimus) New status: Needs review
2025-09-03 07:19:04 Jim Jones (jimus) New status: Waiting on Author
2025-09-02 06:07:47 Andrew Klychkov (andreiklychkov) Attached mail thread CA+mfrmwsBmYsJayWjc8bJmicxc3phZcHHY=yW5aYe=P-1d_4bg@mail.gmail.com
2025-09-02 06:07:47 Andrew Klychkov (andreiklychkov) Created patch record
Edit