[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:  new
 Priority:  medium             |  Milestone:  PostGIS 3.5.0
Component:  postgis            |    Version:  3.4.x
 Keywords:                     |
-------------------------------+---------------------------
 After installing PostGIS_Full_Version reports this


 {{{
 SELECT PostGIS_Full_Version();
 postgis_full_version
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.5.0dev 3.4.0rc1-1272-g80806376a" [EXTENSION] PGSQL="140"
 GEOS="3.12.1-CAPI-1.18.1" PROJ="9.3.0" LIBXML="2.9.13" LIBPROTOBUF="1.3.3"
 WAGYU="0.5.0 (Internal)" (core procs from "3.5.0dev
 3.4.0rc1-1109-g88f11a406" need upgrade) TOPOLOGY (topology procs from
 "3.5.0dev 3.4.0rc1-1109-g88f11a406" need upgrade)
 (1 row)

 }}}

 I then upgrade and I get this error


 {{{
 SELECT PostGIS_Extensions_Upgrade();

 NOTICE:  00000: Updating extension postgis 3.5.0dev
 LOCATION:  exec_stmt_raise, pl_exec.c:3869
 ERROR:  42883: could not find function "ST_RemoveIrrelevantPointsForView"
 in file "/usr/lib/postgresql/14/lib/postgis-3.so"
 CONTEXT:  SQL statement "ALTER EXTENSION postgis UPDATE TO "ANY";ALTER
 EXTENSION postgis UPDATE TO "3.5.0dev""
 PL/pgSQL function postgis_extensions_upgrade(text) line 88 at EXECUTE
 LOCATION:  load_external_function, dfmgr.c:129

 }}}


 I found when testing [https://trac.osgeo.org/postgis/ticket/5766]
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5768>
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.