Opened 3 months ago

Last modified 3 months ago

#5768 closed defect

PostGIS_Extensions_Upgrade() with this code https://gitlab.com/larsop/postgis — at Version 1

Reported by: Lars Aksel Opsahl Owned by: pramsey
Priority: medium Milestone: PostGIS 3.5.0
Component: postgis Version: 3.4.x
Keywords: Cc:

Description (last modified by strk)

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

Change History (1)

comment:1 by strk, 3 months ago

Description: modified (diff)

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 ?

Note: See TracTickets for help on using tickets.