Hello it might be caused by the fact that geometries are originally 4D according to this restriction:
CONSTRAINT enforce_dims_the_geom CHECK ((st_ndims(the_geom) = 4)) Regards, Juan Lucas Domínguez Rubio --- Prodevelop SL, Valencia (España) Tlf.: 96.351.06.12 -- Fax: 96.351.09.68 http://www.prodevelop.es <http://www.prodevelop.es/> --- ________________________________ De: [email protected] en nombre de G. Allegri Enviado el: lun 13/06/2011 16:34 Para: Users and Developers mailing list CC: gvSIG developers mailing list Asunto: Re: [gvSIG-devel] [Gvsig_english] Postgis error on gvSIG-1.11 I've tried to reproduce it with my own build from trunk and it works fine. So I suppose the problem has been solved and will be available in the Gvsig release. If I can extract the new jars that solve it, I will send you them. giovanni 2011/6/13 G. Allegri <[email protected]> I could reproduce it. It seems to be caused by the multilnestring structure. If you explode the geometries as linestrings, they are loaded correctly CREATE TABLE base_ave_view AS SELECT gid,the_geom FROM (SELECT gid,ST_GeometryN(the_geom,generate_series(1,ST_NumGeometries(the_geom))) AS the_geom FROM base_ave) AS foo The multilinestrings contain uno linestring each, except the one with gid 68 (2 linestrings). I'll try to investigate it as soon as I find the time... giovanni 2011/6/13 Nacho Uve <[email protected]> Hi, I load a postgis layer on gvSIG-1.11 and I got a strange error. I attach a screenshot of the error, a sql with the table and the log file. Any pointer about the problem? Regards, Nacho V. -- Juan Ignacio Varela García _______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
_______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
