Hello -

I am attempting to insert features into a PostGIS table.  I create my
feature types from the postgis table itself and construct the features from
that.  One of the feature attributes is an hstore attribute.  The schema is
being correctly read from the PostGIS table and GeoTools is correctly able
to build a feature type where the attribute is an hstore object type.

When it comes to constructing the SQL statements, the PostGIS dialect
plugin is inserting the hstore attribute as such:

'{"PROP_1": "VALUE_1", "PROP_2":"VALUE_2"}'

However - this is incorrect syntax for specifying an hstore value in
Postgres.

The correct syntax is:

' "PROP_1" => "VALUE_1", "PROP_2" => "VALUE_2"'

Is this a known bug or am I missing something?
_______________________________________________
GeoTools-GT2-Users mailing list
GeoTools-GT2-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Reply via email to