<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17097" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText48476>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello</FONT></DIV>
<DIV>it might be caused by the fact that geometries are originally 4D according to this restriction:</DIV>
<DIV> </DIV>
<DIV>CONSTRAINT enforce_dims_the_geom CHECK ((st_ndims(the_geom) = 4))</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV></DIV>
<DIV id=idSignature43085>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig-desktop-devel-bounces@lists.forge.osor.eu en nombre de G. Allegri<BR><B>Enviado el:</B> lun 13/06/2011 16:34<BR><B>Para:</B> Users and Developers mailing list<BR><B>CC:</B> gvSIG developers mailing list<BR><B>Asunto:</B> Re: [gvSIG-devel] [Gvsig_english] Postgis error on gvSIG-1.11<BR></FONT><BR></DIV>
<DIV>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.<BR>
<DIV class=gmail_quote>If I can extract the new jars that solve it, I will send you them.
<DIV><BR>giovanni<BR><BR><BR></DIV>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid"><BR>
<DIV class=gmail_quote>2011/6/13 G. Allegri <SPAN><<A href="mailto:giohappy@gmail.com">giohappy@gmail.com</A>></SPAN>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I could reproduce it.<BR>It seems to be caused by the multilnestring structure. If you explode the geometries as linestrings, they are loaded correctly<BR><BR>CREATE TABLE base_ave_view AS SELECT gid,the_geom<BR>FROM (SELECT gid,ST_GeometryN(the_geom,generate_series(1,ST_NumGeometries(the_geom))) AS the_geom FROM base_ave) AS foo<BR><BR>The multilinestrings contain uno linestring each, except the one with gid 68 (2 linestrings).<BR>I'll try to investigate it as soon as I find the time...<BR><BR>giovanni<BR><BR>
<DIV class=gmail_quote>
<DIV>
<DIV></DIV>
<DIV>2011/6/13 Nacho Uve <SPAN><<A href="mailto:nachouve@gmail.com">nachouve@gmail.com</A>></SPAN><BR></DIV></DIV>
<BLOCKQUOTE class=gmail_quote style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV></DIV>
<DIV>Hi,<BR><BR>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.<BR><BR>Any pointer about the problem?<BR><BR>Regards,<BR>Nacho V.<BR><FONT color=#888888><BR>-- <BR>
<DIV>
<DIV>Juan Ignacio Varela García <BR></DIV>
<DIV><BR></DIV></DIV><BR></FONT><BR></DIV></DIV>_______________________________________________<BR>Gvsig_internacional mailing list<BR><A href="mailto:Gvsig_internacional@listserv.gva.es">Gvsig_internacional@listserv.gva.es</A><BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR><BR></BLOCKQUOTE></DIV><BR>
<DIV style="PADDING-RIGHT: 0px; MARGIN-TOP: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; PADDING-BOTTOM: 0px; MARGIN-LEFT: 0px; OVERFLOW: hidden; COLOR: black; LINE-HEIGHT: 130%; PADDING-TOP: 0px; TEXT-ALIGN: left; WORD-WRAP: break-word"></DIV></BLOCKQUOTE></DIV></DIV></DIV><BR>
<DIV style="PADDING-RIGHT: 0px; MARGIN-TOP: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; PADDING-BOTTOM: 0px; MARGIN-LEFT: 0px; OVERFLOW: hidden; COLOR: black; LINE-HEIGHT: 130%; PADDING-TOP: 0px; TEXT-ALIGN: left; WORD-WRAP: break-word"></DIV></BLOCKQUOTE></DIV><BR>
<DIV id=avg_ls_inline_popup style="PADDING-RIGHT: 0px; MARGIN-TOP: 0px; PADDING-LEFT: 0px; FONT-SIZE: 10px; Z-INDEX: 9999; LEFT: -5000px; VISIBILITY: hidden; PADDING-BOTTOM: 0px; MARGIN-LEFT: 0px; OVERFLOW: hidden; COLOR: black; LINE-HEIGHT: 130%; PADDING-TOP: 0px; POSITION: absolute; TEXT-ALIGN: left; WORD-WRAP: break-word"></DIV></DIV></BODY></HTML>