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

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v3, 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-07-24 21:09:58 (yesterday)

Latest email

2025-07-25 14:15:17 (17 hours ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Ready for Committer

Target version

stable

Authors

Nathan Bossart (bossartn)

Reviewers

Laurenz Albe (laurenz)Become reviewer

Committer

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-07-25 14:15:17 by Nathan Bossart <nathandbossart at gmail.com>
Latest 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>
    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-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