After installing dev-db/postgis-3.3.3 and upgrading a database with SELECT PostGIS_Extensions_Upgrade(); # SELECT postgis_full_version(); still reports "need upgrade" Reproducible: Always Steps to Reproduce: 1. # SELECT PostGIS_Extensions_Upgrade(); HINWEIS: Updating extension postgis 3.3.3 postgis_extensions_upgrade ------------------------------------------------------------------------------------ Upgrade to version 3.3.3 completed, run SELECT postgis_full_version(); for details (1 Zeile) 2. # SELECT postgis_full_version(); postgis_full_version -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- POSTGIS="3.3.3 POSTGIS_REVISION" [EXTENSION] (liblwgeom version mismatch: "3.3.3 2355e8e") PGSQL="120" GEOS="3.12.0-CAPI-1.18.0" PROJ="9.2.1" LIBXML="2.11.4" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" (core procs from "3.3.3 2355e8e" need upgrade) (1 Zeile) Actual Results: # SELECT postgis_scripts_installed(), postgis_scripts_released(); postgis_scripts_installed | postgis_scripts_released ---------------------------+-------------------------- 3.3.3 2355e8e | 3.3.3 POSTGIS_REVISION Expected Results: Probably postgis_scripts_installed output should match with postgis_scripts_released output.
This is still an issue with postgis-3.3.7: # SELECT PostGIS_Extensions_Upgrade(); HINWEIS: Updating extension postgis 3.3.5 postgis_extensions_upgrade ------------------------------------------------------------------------------------ Upgrade to version 3.3.7 completed, run SELECT postgis_full_version(); for details (1 Zeile) # SELECT postgis_full_version(); postgis_full_version ------------------------------------------------------------------------------------ POSTGIS="3.3.7 POSTGIS_REVISION" [EXTENSION] (liblwgeom version mismatch: "3.3.7 a0c7967") PGSQL="120" GEOS="3.12.1-CAPI-1.18.1" PROJ="9.4.1" LIBXML="2.13.5" LIBJSON="0.18" LIBPROTOBUF="1.5.0" WAGYU="0.5.0 (Internal)" (core procs from "3.3.7 a0c7967" need upgrade) (1 Zeile) # SELECT postgis_scripts_installed(), postgis_scripts_released(); postgis_scripts_installed | postgis_scripts_released ---------------------------+-------------------------- 3.3.7 a0c7967 | 3.3.7 POSTGIS_REVISION (1 Zeile)
