[postgis-users] SQL Update

Nicolas Ribot nicky666 at gmail.com
Wed Jul 13 12:37:52 PDT 2005


> Hi List, 
>   
> I would like anyone take a look on this SQL and see what is wrong. 
>   
> Please, nobody knows why it occours yet. 
>   

As the error message said: you are working on 2 geometries with different SRID:
the_geom column on enveloppe table has an SRID != 0.
The multipolygon you are building from text has an SRID set to 0.

Change your polygon textual representation to set an SRID equal to the
one in the_geom table, or change the_geom srid to be 0

Nicolas



More information about the postgis-users mailing list