Opened 3 months ago

Last modified 3 months ago

#5768 closed defect

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

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

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

Change History (0)

Note: See TracTickets for help on using tickets.