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

From: "Regina Obe" <lr(at)pcorp(dot)us>
To: <strk(at)kbt(dot)io>, <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: [PATCH] Support % wildcard in extension upgrade filenames
Date: 2022-05-27 21:37:12
Message-ID: 001d01d87211$edbd5b50$c93811f0$
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

> At PostGIS we've been thinking of ways to have better support, from
> PostgreSQL proper, to our upgrade strategy, which has always consisted in
> SINGLE upgrade file good for upgrading from any older version.
> The current lack of such support for EXTENSIONs forced us to install a lot
> files on disk and we'd like to stop doing that at some point in the
> The proposal is to support wildcards for versions encoded in the filename
> that (for our case) a single wildcard could match "any version". I've been
> thinking about the '%' character for that, to resemble the wildcard used
> Here's the proposal:
> A very very short (and untested) patch which might (or might not) support
> case is attached.
> The only problem with my proposal/patch would be the presence, on the
> of PostgreSQL EXTENSION actually using the '%' character in their version
> strings, which is currently considered legit by PostgreSQL.
> How do you feel about the proposal (which is wider than the patch) ?
> --strk;
> Libre GIS consultant/developer
[Regina Obe]

Just a heads up about the above, Sandro has added it as a commitfest item
which hopefully we can polish in time for PG16.

Does anyone think this is such a horrible idea that we should abandon all

The main impetus is that many extensions (postgis, pgRouting, and I'm sure
others) have over 300 extensions script files that are exactly the same.
We'd like to reduce this footprint significantly.

strk said the patch is crappy so don't look at it just yet. We'll work on
polishing it. I'll review and provide docs for it.


In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Ranier Vilela 2022-05-28 00:15:50 Re: Improving connection scalability (src/backend/storage/ipc/procarray.c)
Previous Message Andres Freund 2022-05-27 21:22:40 Re: Improving connection scalability (src/backend/storage/ipc/procarray.c)