Opened 10 years ago

Closed 5 years ago

#2740 closed defect (fixed)

postgis_full_version registering procs need upgrade

Reported by: robe Owned by: strk
Priority: medium Milestone: PostGIS 2.4.6
Component: build Version: 2.4.x
Keywords: Linux 4.18.5, PostgreSQL 10.5 Cc: andischi

Description

This might be just a windows problem. Testing 2.0.6

SELECT postgis_full_version();

Gives:

POSTGIS="2.0.6" GEOS="3.4.2-CAPI-1.8.2 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.0.6" need upgrade) RASTER (raster procs from "2.0.6" need upgrade)

Problems seems to be that scripts installed and scripts released don't agree

SELECT postgis_scripts_installed(), postgis_scripts_released();

postgis_scripts_installed | postgis_scripts_released
--------------------------+--------------------------
2.0.6                     | 2.0.6 r0

I still need to check 2.1

Change History (11)

comment:1 by robe, 10 years ago

Component: postgisbuild/upgrade/install
Owner: changed from pramsey to strk

comment:2 by robe, 10 years ago

I just tested my 2.1.3 package on PostgreSQL 9.3x64 install. It doesn't have the same issue. So it seems its only 2.0.6 that has this issue.

comment:3 by Bborie Park, 10 years ago

Maybe I'm doing something wrong but on tag 2.0.6 with the queries…

SELECT postgis_scripts_installed(), postgis_scripts_released();
 postgis_scripts_installed | postgis_scripts_released 
---------------------------+--------------------------
 2.0.6 r12554              | 2.0.6 r12554
SELECT postgis_full_version();
POSTGIS="2.0.6 r12554" GEOS="3.5.0dev-CAPI-1.9.0 r3963" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11dev, released 2013/04/13" LIBXML="2.8.0" LIBJSON="UNKNOWN" RASTER

On 2.1.3 with the same queries…

 postgis_scripts_installed | postgis_scripts_released 
---------------------------+--------------------------
 2.1.3 r12547              | 2.1.3 r12547
POSTGIS="2.1.3 r12547" GEOS="3.5.0dev-CAPI-1.9.0 r3963" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.11dev, released 2013/04/13" LIBXML="2.8.0" LIBJSON="UNKNOWN" RASTER

comment:4 by robe, 10 years ago

Keywords: windows added

okay seems to be just a windows problem. I do recall we had this before when strk changed the perl script and how it parsed things. Maybe there is something that wasn't backported to 2.0 that only windows is sensitive to.

comment:5 by robe, 10 years ago

Keywords: mingw64 added

comment:6 by strk, 9 years ago

anything to do here robe ?

comment:7 by robe, 9 years ago

Resolution: wontfix
Status: newclosed

Are we planning to do a 2.0 release soon - 2.0 is SOOOO 2.0. Don't care don't care.

2.1 is fine so I'll close this.

comment:8 by andischi, 6 years ago

Cc: andischi added
Keywords: Linux 4.18.5 PostgreSQL 10.5 added; windows mingw64 removed
Milestone: PostGIS 2.0.7PostGIS 2.4.5
Resolution: wontfix
Status: closedreopened
Version: 2.0.x2.4.x
SELECT version();
PostgreSQL 10.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.2.0, 64-bit
SELECT postgis_full_version();
postgis_full_version | POSTGIS="2.4.4 r16526" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" PROJ="Rel. 5.1.0, June 1st, 2018" GDAL="GDAL 2.3.1, released 2018/06/22" LIBXML="2.9.8" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0" (core procs from "2.4.3 r16312" need upgrade) TOPOLOGY (topology procs from "2.4.3 r16312" need upgrade) RASTER (raster procs from "2.4.3 r16312" need upgrade)
SELECT postgis_scripts_installed(), postgis_scripts_released();
 postgis_scripts_installed | postgis_scripts_released 
---------------------------+--------------------------
 2.4.3 r16312              | 2.4.4 r16526
Last edited 6 years ago by andischi (previous) (diff)

comment:9 by andischi, 6 years ago

Summary: postgis_full_version registering procs need upgrade on windowspostgis_full_version registering procs need upgrade

comment:10 by pramsey, 6 years ago

Milestone: PostGIS 2.4.5PostGIS 2.4.6

comment:11 by strk, 5 years ago

Resolution: fixed
Status: reopenedclosed

andischi your reported output seems legit to me, not what the original submission was about. Closing again (and r17296 might have fixed other similar issues too)

Note: See TracTickets for help on using tickets.