RE: [PATCH] Support % wildcard in extension upgrade filenames - Mailing list pgsql-hackers

From Regina Obe
Subject RE: [PATCH] Support % wildcard in extension upgrade filenames
Date
Msg-id 002301d976d6$a934d0b0$fb9e7210$@pcorp.us
Whole thread Raw
In response to Re: [PATCH] Support % wildcard in extension upgrade filenames  (Mat Arye <mat@timescaledb.com>)
List pgsql-hackers
> This change also makes it easier for extensions that use versioned .so files (by that I mean uses
extension-<version>.sorather than extension.so).  
> Because such extensions can't really use the chaining property of the existing upgrade system and so need to write a
directX--Y.sql migration file for  
> every prior version X. I know the system wasn't designed for this, but in reality a lot of extensions do this.
Especiallythe more complex ones. 

> Hopefully this is helpful,
> Mat

Thanks for the feedback.  Yes this idea of versioned .so is also one of the reasons why we always have to run a replace
onall functions. 

Like for example on PostGIS side, we have option of full minor (so the lib could be postgis-3.3.so  or postgis-3.so)

For development I always include the minor version and the windows interim builds I build against our master branch has
theminor. 
But the idea is someone can upgrade to stable version, so the script needs to always have the .so version in it to
accountfor this shifting of options. 

Thanks,
Regina




pgsql-hackers by date:

Previous
From: Yurii Rashkovskii
Date:
Subject: Re: [PATCH] Extend the length of BackgroundWorker.bgw_library_name
Next
From: Phil Florent
Date:
Subject: RE: Should we remove vacuum_defer_cleanup_age?