<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="IncrediMail 1.0" name=GENERATOR></HEAD>
<BODY style="BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px 10px 10px; FONT-FAMILY: Arial" bgColor=#ffffff background="" scroll=yes ORGYPOS="0">
<TABLE id=INCREDIMAINTABLE cellSpacing=0 cellPadding=2 width="100%" border=0>
<TBODY>
<TR>
<TD id=INCREDITEXTREGION style="FONT-SIZE: 12pt; CURSOR: auto; FONT-FAMILY: Arial" width="100%">
<DIV>This have something to do with my jdbc driver is pg74jdbc3.jar and my postgresql is 8.0 ?</DIV>
<DIV> </DIV>
<DIV>I load my themes by shp2pgsql and I passed the SRID parameter "-s <option>".</DIV>
<DIV> </DIV>
<DIV>I don't know if the plugin works fine to everyone because nobody reported it to me.</DIV>
<DIV> </DIV>
<DIV>I Hope you could help me.</DIV>
<DIV> </DIV>
<DIV>Sincerely</DIV>
<DIV>Ezequias</DIV>
<DIV> </DIV>
<DIV id=IncrediOriginalMessage><I>-------Mensagem original-------</I></DIV>
<DIV> </DIV>
<DIV id=receivestrings>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>De:</B></I> <A href="mailto:nicky666@gmail.com">Nicolas Ribot</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Data:</B></I> 07/14/05 15:04:45</DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Para:</B></I> <A href="mailto:postgis-users@postgis.refractions.net">PostGIS Users Discussion</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Assunto:</B></I> Re: Res: Re: [postgis-users] SQL Update</DIV></DIV>
<DIV> </DIV>
<DIV>> Nicolas,</DIV>
<DIV>></DIV>
<DIV>> What Multipolygon are you talking about ?</DIV>
<DIV>></DIV>
<DIV>> I think that I was updating only one layer at time.</DIV>
<DIV>></DIV>
<DIV> </DIV>
<DIV>In your post, the attached image showed the query generating the error message.</DIV>
<DIV>In it, when the envelope table is updated, the where clause references</DIV>
<DIV>a multipolygon whose SRID is 0.</DIV>
<DIV>According to the error message, the "envelope" table has another SRID.</DIV>
<DIV>You should check it (in the geometry_columns table).</DIV>
<DIV> </DIV>
<DIV>Nicolas</DIV>
<DIV>_______________________________________________</DIV>
<DIV>postgis-users mailing list</DIV>
<DIV><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV>
<DIV><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV></TD></TR>
<TR>
<TD id=INCREDIFOOTER width="100%">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD width="100%"></TD>
<TD id=INCREDISOUND vAlign=bottom align=middle></TD>
<TD id=INCREDIANIM vAlign=bottom align=middle></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><SPAN id=IncrediStamp><SPAN dir=ltr><A href="http://www.incredimail.com/index.asp?id=54760"><IMG alt="Add FUN to your email - CLICK HERE!" hspace=0 src="http://www2.incredimail.com/contents/stamps/imstp_emo_pt.gif" align=baseline border=0></A></SPAN></SPAN></BODY></HTML>