[postgis-users] Questions about using SRID not -1

[Oscar Zamudio]

Thanks Kevin but Chris Hermansen gave us the key and the problem is solved
now. Please follow my post (my partner Mario actually answered) with the
subjec 'SOLVED!!' and there's all explained.
Regards,

Oscar


On Fri, Jan 22, 2010 at 1:28 PM, Kevin Neufeld <kneufeld at refractions.net>wrote:

> On 1/21/2010 12:14 PM, Oscar Zamudio wrote:
>
>> I already tried this way:
>>
>> UPDATE mypoints SET the_geom = ST_SetSRID(the_geom,4326);
>>
>> But I got:
>>
>> ERROR:  Operation on two GEOMETRIES with different SRIDs
>>
>>
> This doesn't make sense to me.  ST_SetSRID simply updates the internal
> structure of the geometry.  It's not doing any operation on the geometry.
>  Do you maybe have a TRIGGER and/or RULE on the table that is invoking
> another function on an UPDATE operation?
>
> Try this:
> CREATE TABLE mypoints2 AS SELECT the_geom FROM mypoints;
> UPDATE mypoints2 SET the_geom = ST_SetSRID(the_geom,4326);
>
> If that doesn't work, can you please isolate an example?  On what geometry
> exactly is the ERROR thrown?
>
> -- Kevin
>
> _______________________________________________
> 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/20100122/d198904c/attachment.html>