shape to postgis example -> only point features fail.

_AnonymousUser — Sat, 16 Nov 2024 13:54:05 GMT

Hello all,
I've tryied the sample of SDI to insert shape features to postgis. All geometries run fine except for the Points. I got this error:
GRAVE: SQL Exception writing geometry columnERROR: new row for relation "_essai_sdi_plop2" violates check constraint "enforce_geotype_the_geom"
The table is created, but empty.
At the creation of the table, SDI wrote this:
ADD CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype("the_geom") = 'POINTM'::text OR "the_geom" IS NULL);
Seems that Postgis is not happy with the check constraint. Something strange is the name of this constrain: 'POINTM' why not 'POINT' ? Is it relevant or not? (I'm not sure to understand what happend behind this check constrain.)
I've tryied the same data with FME into postgis: the resulting geometry was multipoint. So I've tryied with SDI to convert with multipoint geometry:
INFO: ALTER TABLE "public"."_essai_sdi_plop2" ADD CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype("the_geom") = 'MULTIPOINTM'::text OR "the_geom" IS NULL);
This time all attributes are written, but geometries are null.
If someone has any id about what is going on with this sdi sample and point features, that for feedback!
Rémy

Re: shape to postgis example -> only point features fail.

_AnonymousUser — Thu, 25 Jun 2009 16:08:19 GMT

Dear Poulet1212,
this is an issue of the current PostgisDataStore.java of Geotools, an issue has been posted thatfore.
Hope this helps.
regards

Re: shape to postgis example -> only point features fail.

Anonymous — Sun, 24 Jan 2010 17:44:18 GMT

Try to use a tPostgresOutput component instead or set geometry type to geometry instead of point.
HTH.
Francois

topic Re: shape to postgis example -> only point features fail. in Talend Studio

shape to postgis example -> only point features fail.

Re: shape to postgis example -> only point features fail.

Re: shape to postgis example -> only point features fail.