Horton
Menu

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

Regina Obe <lr@pcorp.us>

View thread
From: "Regina Obe" <lr@pcorp.us>
To: "'Robert Haas'" <robertmhaas@gmail.com>, "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: "'Sandro Santilli'" <strk@kbt.io>, "'Regina Obe'" <r@pcorp.us>, <pgsql-hackers@lists.postgresql.org>
Date: 2023-03-07T19:25:09Z
Lists: pgsql-hackers 
> The thing that confuses me here is why the PostGIS folks are ending up with
> so many files. 
> We certainly don't have that problem with the extension that
> are being maintained in contrib, and I guess there is some difference in
> versioning practice that is making it an issue for them but not for us. I wish I
> understood what was going on there.

The contrib files are minor versioned.  PostGIS is micro versioned.

So we have for example postgis--3.3.0--3.3.1.sql
Also we have 5 extensions we ship all micro versions, so multiply that issue by 5

postgis
postgis_raster
postgis_topology
postgis_tiger_geocoder
postgis_sfcgal

The other wrinkle we have that I don't think postgresql's contrib have is that we support 
Each version across multiple PostgreSQL versions.
So for example our 3.3 series supports PostgreSQL 12-15 (with plans to also support 16).