[postgis-users] Error: "Precision reduction requires GEOS-3.9 or higher"

[Marco Boeringa]

Hi Paul,

In addition to the information in the last post included below, in 
Synaptic Package Manager, for the 'focal-pgdg/main(apt.postgresql.org)' 
repo, I have the following selected / installed:

Package: postgresql-13-postgis-3 | Installed version: 
3.1.1+dfsg-1.pgdg20.04+1

Package: postgresql-13-postgis-3-scripts | Installed version: 
3.1.1+dfsg-1.pgdg20.04+1

Marco

Op 17-4-2021 om 09:01 schreef Marco Boeringa:
> Hi Paul,
>
> Thanks for the response.
>
> The virtual machine is a Microsoft "Hyper-V" instance with Ubuntu 
> 20.04.2 LTS, as provided by Microsoft, that I upgraded by installing 
> PostgreSQL and PostGIS from the included Synaptic Package Manager, 
> which AFAIK references the official repositories for PostgreSQL and 
> ubuntugis, and the Canonical Partners repository:
>
> "http://apt.postgresql.org/pub/repos/apt/focal-pgdg main"
>
> "http://ppa.launchpad.net/ubuntugis/ppa/ubuntu focal main"
>
> Before I upgraded libgeos from the ubuntugis repository, 
> "PostGIS_Full_Version()" showed GEOS 3.8.0.
>
> So how do I potentially solve this? Or is this upgrade of GEOS only 
> possible by compiling PostGIS from source yourself (which I would 
> definitely like to avoid)?
>
> Marco
>
> Op 16-4-2021 om 23:58 schreef Paul Ramsey:
>> It's curious, but the implication is that the postgis on your machine 
>> was built against an earlier GEOS. The version number that postgis 
>> reports for GEOS is generated at run-time, while the test of whether 
>> to include support for various functions is determined at 
>> compile-time. Hence you can see a "GEOS 3.9" version in your postgis, 
>> but still not have access to functions that are 3.9+ only.
>>
>> P
>>
>>> On Apr 16, 2021, at 2:53 PM, Marco Boeringa 
>>> <marco at boeringa.demon.nl> wrote:
>>>
>>> Hi all,
>>>
>>> I upgraded my Ubuntu 20.04 instance with "libgeos-3.9.0" from the 
>>> ubuntugis repository.
>>>
>>> When I use:
>>>
>>> "SELECT PostGIS_Full_Version();"
>>>
>>> I get back:
>>>
>>> POSTGIS="3.1.1 aaf4c79" [EXTENSION] PGSQL="130" 
>>> GEOS="3.9.0-CAPI-1.16.2" PROJ="6.3.1" LIBXML="2.9.10" 
>>> LIBJSON="0.13.1" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
>>>
>>> which at least suggests I am now correctly using GEOS 3.9.0 (note: I 
>>> updated the PostGIS extension's functions using "ALTER EXTENSION 
>>> postgis UPDATE")
>>>
>>> However, after adjusting some existing code to include the new 
>>> "ST_ReducePrecision" PostGIS function 
>>> (https://postgis.net/docs/ST_ReducePrecision.html), which is new in 
>>> 3.9.0, I get back an error:
>>>
>>> "Precision reduction requires GEOS-3.9 or higher"
>>>
>>> which seems weird given the "PostGIS_Full_Version" result. Anyone 
>>> have a clue as to what I missed?
>>>
>>> Marco
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users