Re: [PATCH] Support % wildcard in extension upgrade filenames

Sandro Santilli <strk@kbt.io>

From: 'Sandro Santilli' <strk@kbt.io>
To: Regina Obe <lr@pcorp.us>
Cc: 'Tom Lane' <tgl@sss.pgh.pa.us>, 'Regina Obe' <r@pcorp.us>, pgsql-hackers@lists.postgresql.org
Date: 2023-01-11T10:16:36Z
Lists: pgsql-hackers
On Tue, Jan 10, 2023 at 11:09:23PM -0500, Regina Obe wrote:

> The only way we can fix that in the current setup, is to move to a minor
> version mode which means we can 
> never do micro updates.

Or just not with standard PostgreSQL syntax, because we can of course
do upgrades using the `SELECT postgis_extensions_upgrade()` call at
the moment, which, if you ask me, sounds MORE dangerous than the
wildcard upgrade approach because the _implementation_ of that
function will always be the OLD implementation, never the NEW one,
so if bogus cannot be fixed by a new release w/out a way to upgrade
there...

--strk;