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

From: Przemysław Sztoch <przemyslaw(at)sztoch(dot)pl>
To: Yurii Rashkovskii <yrashk(at)gmail(dot)com>
Cc: Eric Ridge <eebbrr(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Regina Obe <lr(at)pcorp(dot)us>, strk(at)kbt(dot)io, Regina Obe <r(at)pcorp(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] Support % wildcard in extension upgrade filenames
Date: 2023-05-18 21:14:52
Message-ID: 29e81ac7-9fad-573a-6319-9a8265320c2d@sztoch.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

For me, it would be a big help if you could specify a simple from/to
range as the source version:
myext--1.0.0-1.9.9--2.0.0.sql
myext--2.0.0-2.9.9--3.0.0.sql
myext--3.0.0-3.2.3--3.2.4.sql

The idea of % wildcard in my opinion is fully contained in the from/to
range.

The name "ANY" should also be allowed as the source version.
Some extensions are a collection of CREATE OR REPLACE FUNCTION. All
upgrades are one and the same SQL file.

For example: address_standardizer_data_us--ANY--3.2.4.sql
--
Przemysław Sztoch | Mobile +48 509 99 00 66

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan S. Katz 2023-05-18 21:26:17 Re: PG 16 draft release notes ready
Previous Message Tom Lane 2023-05-18 21:03:24 Re: Add operator for dividing interval by an interval