[PATCH] Support % wildcard in extension upgrade filenames

From: Sandro Santilli <strk(at)kbt(dot)io>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [PATCH] Support % wildcard in extension upgrade filenames
Date: 2022-02-11 17:59:50
Message-ID: YgakFklJyM5pNdt+@c19
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 a SINGLE upgrade file good for upgrading from any older version.

The current lack of such support for EXTENSIONs forced us to install
a lot of files on disk and we'd like to stop doing that at some point
in the future.

The proposal is to support wildcards for versions encoded in the
filename so 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 for LIKE.

Here's the proposal:

A very very short (and untested) patch which might (or
might not) support our case is attached.

The only problem with my proposal/patch would be the presence, on the
wild, of PostgreSQL EXTENSION actually using the '%' character in
their version strings, which is currently considered legit by

How do you feel about the proposal (which is wider than the patch) ?


Libre GIS consultant/developer

Attachment Content-Type Size
0001-Support-wildcard-in-extension-upgrade-scripts.patch text/x-diff 769 bytes


Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2022-02-11 18:02:49 Re: O(n) tasks cause lengthy startups and checkpoints
Previous Message Bruce Momjian 2022-02-11 17:50:49 Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints