[Gvsig_english] [gvSIG-devel] Postgis error on gvSIG-1.11

[Juan Lucas Dominguez Rubio]

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: gvsig-desktop-devel-bounces at lists.forge.osor.eu 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 <giohappy at gmail.com> 


		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 <nachouve at gmail.com>
		

			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
			Gvsig_internacional at listserv.gva.es
			http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
			
			




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20110613/64df2d56/attachment.htm