`ALTER DATABASE ... RESET ...` fails to reset extension parameters that no longer exist

Edit
ID 5840
Title `ALTER DATABASE ... RESET ...` fails to reset extension parameters that no longer exist
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 1, First patch: +71−5, All patches: +71−5
Topic Bug Fixes
Tags
Created 2025-06-23 21:05:43
Last modified 2025-08-01 21:57:10 (2 months ago)
Latest email 2025-08-01 22:01:47 (2 months ago)
Status
PG19-2 (2025-09-01 – 2025-09-30): Committed
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version stable
Authors Nathan Bossart (bossartn)
Reviewers Laurenz Albe (laurenz)Become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
BUG #18964: `ALTER DATABASE ... RESET ...` fails to reset extension parameters that no longer exist
First at 2025-06-20 12:24:20 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2025-08-01 22:01:47 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v1-0001-Allow-ALTER-SYSTEM-to-set-unrecognized-custom.patch.v15) at 2025-07-30 19:13:16 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v1-0001-Allow-ALTER-SYSTEM-to-set-unrecognized-custom.patch.v15) at 2025-07-30 19:13:16 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Allow-resetting-unknown-custom-GUCs-with-reserved.patch) at 2025-07-25 14:15:17 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Allow-resetting-unknown-custom-GUCs-with-reserved.patch) at 2025-07-24 16:30:49 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Allow-resetting-unknown-custom-GUCs-with-reserved.patch) at 2025-06-25 16:06:05 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (fix_alter_role_reset_v1.patch) at 2025-06-20 22:48:37 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
History
When Who What
2025-08-01 21:57:10 Nathan Bossart (bossartn) Closed in commitfest PG19-2 with status: Committed
2025-08-01 21:57:09 Nathan Bossart (bossartn) Changed committer to bossartn
2025-08-01 13:41:10 Nathan Bossart (bossartn) Moved from CF PG19-1 to CF PG19-2
2025-07-24 21:09:58 Laurenz Albe (laurenz) New status: Ready for Committer
2025-07-24 16:30:59 Nathan Bossart (bossartn) New status: Needs review
2025-07-22 02:27:45 Laurenz Albe (laurenz) Added laurenz as reviewer
2025-07-22 02:27:42 Laurenz Albe (laurenz) New status: Waiting on Author
2025-06-23 21:05:44 Nathan Bossart (bossartn) Attached mail thread 18964-ba09dea8c98fccd6@postgresql.org
2025-06-23 21:05:43 Nathan Bossart (bossartn) Created patch record
Edit