[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
Resolution:                     |   Keywords:
--------------------------------+---------------------------

Old description:

> 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]

New description:

 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]

--
Comment (by strk):

 What does this return ?
 {{{
 nm `pg_config --pkglibdir`/postgis-3.so | grep Remove
 }}}

 The signature should be in the .so file since
 eeb490ce1d4a38f0f19da88aa0569692c8a31b34 -- did you re-run ./configure
 after update ? Did `make check` succeed ?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5768#comment:1>
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.