[postgis-tickets] [PostGIS] #5194: SELECT postgis_extensions_upgrade() fails with pgextwlist
PostGIS
trac at osgeo.org
Sun Jul 31 00:35:55 PDT 2022
#5194: SELECT postgis_extensions_upgrade() fails with pgextwlist
------------------------------------+---------------------------
Reporter: robe | Owner: strk
Type: defect | Status: new
Priority: blocker | Milestone: PostGIS 3.3.0
Component: build/upgrade/install | Version: master
Resolution: | Keywords:
------------------------------------+---------------------------
Comment (by strk):
I'm working on an alternative setup in which rather than messing the
catalog tables to set our version to 'ANY' we install 0-bytes upgrade
paths from any supported version to `ANY`, which does the SAME thing as
the catalog update but using `ALTER EXTENSION UPDATE` instead of `UPDATE
pg_extension`. It will still be good to try the direct catalog update in
case those `<version>--ANY` upgrade files are missing for any reason
(package managers end up dropping them or users want to avoid having all
those files around). The work in progress is in an `upgrade-paths` branch
in official repository
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5194#comment:8>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list