Support for postgis geometry parent type

[javieronsurbe]

Feature Request

PostGIS have support to define a generic geometry type for fields that can contains points, polygons, etc. and this kind of field is supported in Postgres JDBC version using an abstract class that specific ones can inherit.

Can we have some similar behavior in r2dbc one? I.e.- Declaring a field in a POJO of type Geometry (abstract) and when it is recovered from database from a table field of type geometry it is mapped to a specific type (Point, Polygon, etc.)

As I see specific ones support are added (0.8.5 version), maybe it's not very difficult to add this enhancement to driver

Thanks!

[mp911de]

R2DBC's extension model is based on codecs so plugin authors can bring their own type hierarchy. Looking though the code of Postgis JDBC, I haven't found how Postgis registers itself with the JDBC driver. I think you could reuse the same types and provide a Postgis codec to natively read into Geometry types and write such.

Take a look at the HSTORE codec that is being registered conditionally if HSTORE is present: https://github.com/pgjdbc/r2dbc-postgresql/blob/main/src/main/java/io/r2dbc/postgresql/codec/BuiltinDynamicCodecs.java#L32

[javieronsurbe]

Thank you very much for the hint Mark. I will try it. El lun, 24 ene 2022 a las 15:11, Mark Paluch ***@***.***>) escribió:

…

R2DBC's extension model is based on codecs so plugin authors can bring their own type hierarchy. Looking though the code of Postgis JDBC, I haven't found how Postgis registers itself with the JDBC driver. I think you could reuse the same types and provide a Postgis codec to natively read into Geometry types and write such. Take a look at the HSTORE codec that is being registered conditionally if HSTORE is present: https://github.com/pgjdbc/r2dbc-postgresql/blob/main/src/main/java/io/r2dbc/postgresql/codec/BuiltinDynamicCodecs.java#L32 — Reply to this email directly, view it on GitHub <#483 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AEGSEZZ5CRXM3NDCI3QNGBTUXVM2ZANCNFSM5MVOI4XA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you authored the thread.Message ID: ***@***.***>