Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 912275

Summary: dev-db/postgis: postgis_scripts_installed vs. postgis_scripts_released mismatch
Product: Gentoo Linux Reporter: Timo Gurr <timo.gurr>
Component: Current packagesAssignee: PgSQL Bugs <pgsql-bugs>
Status: UNCONFIRMED ---    
Severity: normal CC: sci-geosciences
Priority: Normal    
Version: unspecified   
Hardware: All   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---

Description Timo Gurr 2023-08-14 11:29:38 UTC
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.