Nicolas Ribot a écrit :
hi all,
Sorry for cross posting, i don't know if it is a geoserver (geotools)
problem or a postGIS configuration one.
I have this exception when trying to insert feature in PostGIS through
WFS V1.1 Geoserver 1.6
27 juin 15:01:05 ERROR [data.jdbc] - SQL Exception writing geometry
columnERREUR: La nouvelle ligne pour la relation «ice_geom» viole la
contrainte de vérification «enforce_srid_ice_polygon»
org.postgresql.util.PSQLException: ERREUR: La nouvelle ligne pour la
relation «ice_geom» viole la contrainte de vérification
«enforce_srid_ice_polygon»
at
Hi Sebastien
It seems there is a difference between the ice_polygon SRiD in postgis
and the one sent by the WFS query.
In geoserver, is ice_geom layer configured with the same SRID as
ice_geom table in postgis ?
WFS refers to EPSG:4326 for the ice_geom layer.
You are right.
srid of postGIS column and srid of gml data posted to wfs geoserver were
different (-1 and 4326).
i droped down the constraint on column, change the srdi and create
another constraint.
WFS works fine, loads feature into postGIS.
Merci nico !
what's the output of the following query:
select srid(the_geom) from ice_geom;
Nicolas
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Sébastien Geindre
DPREVI/AERO/DEV
sebastien.geindre __at__ meteo.fr
05 61 07 84 93
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
