[postgis-tickets] [PostGIS] #5194: SELECT postgis_extensions_upgrade() fails with pgextwlist

[PostGIS]

#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):

 Only doing ANY if a path does not exist can surely be done but defeats the
 purpose of using ANY there, which is AVOIDING to install those many
 upgrade paths. There are at the moment 79 upgradeable_versions which
 multiplied by the number of extensions we are installing (6) means 474
 upgrade path files created on the system (slighly more as I belive there'd
 be also the "next" ones). That's the problem we're trying to solve with
 that system catalog update.

 Alternative proposal would be (which would only work from now ON, meaning
 we'll still need to keep the 474 upgrade paths for older releases):

   - Always install a current--ANY
   - Never add the versions released with <version>--ANY to upgradeable-
 path
   - Have postgis_extension_upgrade UPDATE TO ANY; UPDATE;

 How does it sound ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5194#comment:2>
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.