Using PostGIS Geometry types

[JindrichPilar]

When using PostGIS geometry types and storing a record it serializes the Point type incorrectly.
$10::geometry gets as parameter "(50.501899 10.963963)" instead of "Point(50.501899 10.963963)". Insert fails with an error ERROR: invalid input syntax for type point.

Column definition:

gps
    geometry
    not null

Record usage:

val record = dsl.newRecord(Tables.TABLE_WITH_GPS)
record.gps = org.postgis.Point(50.501899, 10.963963)
record.insert() // This throws an error

[zezulka]

I was able to reproduce the same behaviour.

The problem most probably stems from incorrect implementation of PostgisGeometryConverter: https://github.com/dmitry-zhuravlev/jooq-postgis-spatial/blob/master/src/main/kotlin/net/dmitry/jooq/postgis/spatial/converter/PostgisGeometryConverter.kt#L25 . In the context of JTSGeometryBinding, this "native" converter works just fine, the problem is when the converter is used in the context of PostgisGeometryBinding.

When I defined my own converter based on PostgisGeometryConverter which uses

PGobject().apply {
   type = "geometry" // passing in the geometry type string is just plain wrong, PGobject type does not expect enum of ["linestring", "point", ...] but ["geometry", "box2d", ...], see https://postgis.net/docs/reference.html#PostGIS_Types
   value = geom.toString() // this converts postgis geometry to an EWKT string
}

instead of

PGobject().apply {
    type = geom.typeString
    value = geom.value
}

all postgis queries seemed to work properly.