From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nathan Bossart <nathandbossart@gmail.com>
cc: Laurenz Albe <laurenz.albe@cybertec.at>, mert@futo.org,
        pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18964: `ALTER DATABASE ... RESET ...` fails to reset
 extension parameters that no longer exist
In-reply-to: <aIfoWKXanBNGhdwt@nathan>
References: <18964-ba09dea8c98fccd6@postgresql.org> <aFW8R6Qlgtbp7TOk@nathan>
 <2474668.1750451081@sss.pgh.pa.us> <aFXQmZ2sveFAwdjY@nathan>
 <aFXlRTxMxVyMjfjq@nathan> <aFwebUErRdEKZy6i@nathan>
 <803ddef427b9016be04af9320925e9570d3fcc06.camel@cybertec.at>
 <aIJfucaqjZ3gh-xj@nathan>
 <8902b6f8d5c19f09f4a052295b9de41d9f6970b5.camel@cybertec.at>
 <aIORdQ-PJ15k-WjZ@nathan> <aIfoWKXanBNGhdwt@nathan>
Comments: In-reply-to Nathan Bossart <nathandbossart@gmail.com>
	message dated "Mon, 28 Jul 2025 16:15:04 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <768340.1753738070.1@sss.pgh.pa.us>
Date: Mon, 28 Jul 2025 17:27:50 -0400
Message-ID: <768341.1753738070@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/768341.1753738070%40sss.pgh.pa.us>
Precedence: bulk

Nathan Bossart <nathandbossart@gmail.com> writes:
> I looked into how easily this back-patched to v15 (where commit 88103567c
> was added), and I noticed that the ALTER SYSTEM code looks a bit different
> on v15 and v16.  Furthermore, I didn't see a simple way to fix it on those
> versions without first back-patching commit 2d870b4.  From the commit
> message, it looks like Tom didn't back-patch it at the time due to a lack
> of complaints.  I'm currently thinking we should first back-patch that one
> to at least v15, if not all supported versions, before applying my proposed
> patch.  Thoughts?

No objection here.  Now that that's a couple years old, it should have
had enough time to bake.

			regards, tom lane