Using the appender with GEOMETRY type

[ThomasWeiss]

When storing geometries in columns of type BLOB, I have been successful using the appender to write the WKB representation of these geometries as blobs, then querying them back with SELECT ST_AsText(ST_GeomFromWKB(coord)) FROM table;.

I wanted to use the GEOMETRY type instead of BLOB to spare the WKB conversions during queries and to experiment with spatial indices. When creating the columns with the GEOMETRY type, I'm still able to write values using the appender by passing the WKB representation of the geometry to duckdb_append_blob, but then a SELECT ST_AsText(coord) FROM table; fails with Serialization Error: Unknown geometry type (1549010733d). Creating a spatial index on this column fails as well.

I assume trying to write it as a blob is the way to go as duckdb_appender_column_type tells me that column is BLOB, so how should I serialize the geometry if not as WKB?