Spatial support for PostgreSQL 10+ uses invalid WKB dialect

Description

As described in https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS the combination PostgreSQL 10+ requires PostGIS >= 2.3. This means that for PostgisPG10Dialect Wkb.Dialect.POSTGIS_EWKB_2 should be used instead of Wkb.Dialect.POSTGIS_EWKB_1 since EWKB_1 is the dialect for Postgis version < 2.2.1.

However it looks like Wkb.Dialect.POSTGIS_EWKB_1 is used in multiple places when using PostgisPG10Dialect:

I noticed this when I tried to store an empty point in a column of type `GEOMETRY(POINT, 4326)`.

This caused the following SQL error:

Which is exactly as decribed what happens when using the POSTGIS_EWKB1 dialect:

Activity

Show:

Ahmed BahriFebruary 15, 2022 at 8:01 PM

hi

Fixed

Details

Assignee

Reporter

Components

Affects versions

Priority

Created November 17, 2021 at 2:11 PM
Updated February 15, 2022 at 8:01 PM
Resolved February 2, 2022 at 8:40 PM