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
Note:
See TracTickets
for help on using tickets.