Res: Re: Res: Re: [postgis-users] SQL Update

Ezequias Rodrigues da Rocha ezequias at recife.pe.gov.br
Thu Jul 14 11:46:42 PDT 2005


This have something to do with my jdbc driver is pg74jdbc3.jar and my
postgresql is 8.0 ?

I load my themes by shp2pgsql and I passed the SRID parameter "-s <option>".

I don't know if the plugin works fine to everyone because nobody reported it
to me.

I Hope you could help me.

Sincerely
Ezequias
 
-------Mensagem original-------
 
De: Nicolas Ribot
Data: 07/14/05 15:04:45
Para: PostGIS Users Discussion
Assunto: Re: Res: Re: [postgis-users] SQL Update
 
>  Nicolas,
>
> What Multipolygon are you talking about ?
>
> I think that I was updating only one layer at time.
>
 
In your post, the attached image showed the query generating the error
message.
In it, when the envelope table is updated, the where clause references
a multipolygon whose SRID is 0.
According to the error message, the "envelope" table has another SRID.
You should check it (in the geometry_columns table).
 
Nicolas
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050714/2326369b/attachment.html>


More information about the postgis-users mailing list