[PostGIS] #5768: PostGIS_Extensions_Upgrade() with this code https://gitlab.com/larsop/postgis

[PostGIS]

#5768: PostGIS_Extensions_Upgrade() with this code
https://gitlab.com/larsop/postgis
--------------------------------+---------------------------
  Reporter:  Lars Aksel Opsahl  |      Owner:  pramsey
      Type:  defect             |     Status:  closed
  Priority:  medium             |  Milestone:  PostGIS 3.5.0
 Component:  postgis            |    Version:  3.4.x
Resolution:  invalid            |   Keywords:
--------------------------------+---------------------------
Comment (by Lars Aksel Opsahl):

 Tested on another database with the same postgis version but postgresql 12
 and where have also installed postgis_sfcgal. I have different databases
 on this server the database where postgis_sfcgal was not installed the
 upgrade wen OK.

 When postgis_sfcgal is installed I see this problem

 {{{

 SELECT PostGIS_Extensions_Upgrade();
 NOTICE:  00000: Updating extension postgis 3.4.0
 LOCATION:  exec_stmt_raise, pl_exec.c:3862
 NOTICE:  00000: Updating extension postgis_sfcgal ANY
 LOCATION:  exec_stmt_raise, pl_exec.c:3862
 NOTICE:  00000: version "ANY" of extension "postgis_sfcgal" is already
 installed
 LOCATION:  ExecAlterExtensionStmt, extension.c:3002
 ERROR:  22023: extension "postgis_sfcgal" has no update path from version
 "ANY" to version "3.5.0dev"
 CONTEXT:  SQL statement "ALTER EXTENSION postgis_sfcgal UPDATE TO
 "ANY";ALTER EXTENSION postgis_sfcgal UPDATE TO "3.5.0dev""
 PL/pgSQL function postgis_extensions_upgrade(text) line 88 at EXECUTE
 LOCATION:  identify_update_path, extension.c:1111
 vroom5.int.nibio.no postgres at sl=# SELECT PostGIS_Full_Version();
 postgis_full_version
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.5.0dev 3.4.0rc1-1272-g80806376a" [EXTENSION] PGSQL="120"
 GEOS="3.12.1-CAPI-1.18.1" SFCGAL="1.3.7" PROJ="8.2.0" GDAL="GDAL 3.4.3,
 released 2022/04/22" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.3"
 WAGYU="0.5.0 (Internal)" (core procs from "3.4.0 0874ea3" need upgrade)
 TOPOLOGY (topology procs from "3.4.0 0874ea3" need upgrade) RASTER (raster
 procs from "3.4.0 0874ea3" need upgrade) (sfcgal procs from "3.4.0
 0874ea3" need upgrade)
 (1 row)

 }}}

 I also tested


 {{{
 ALTER EXTENSION postgis_sfcgal UPDATE TO "ANY";
 ALTER EXTENSION postgis_sfcgal UPDATE TO "3.5.0dev";
 }}}

 Then I got a new error


 {{{

 ALTER EXTENSION postgis_sfcgal UPDATE TO "ANY";
 NOTICE:  00000: version "ANY" of extension "postgis_sfcgal" is already
 installed
 LOCATION:  ExecAlterExtensionStmt, extension.c:3002
 ALTER EXTENSION

 ALTER EXTENSION postgis_sfcgal UPDATE TO "3.5.0dev";
 ERROR:  22023: extension "postgis_sfcgal" has no update path from version
 "ANY" to version "3.5.0dev"
 LOCATION:  identify_update_path, extension.c:1111

 }}}

 A new error to report or a user error ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5768#comment:3>
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.