|From:||"Regina Obe" <lr(at)pcorp(dot)us>|
|Subject:||RE: [PATCH] Support % wildcard in extension upgrade filenames|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
> 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) ?
> Libre GIS consultant/developer
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.
|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)|