Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 912275 - dev-db/postgis: postgis_scripts_installed vs. postgis_scripts_released mismatch
Summary: dev-db/postgis: postgis_scripts_installed vs. postgis_scripts_released mismatch
Status: UNCONFIRMED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal
Assignee: PgSQL Bugs
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-08-14 11:29 UTC by Timo Gurr
Modified: 2023-08-14 17:45 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.