[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