[postgis-users] UpdateGeometrySRID error

[Sergio Baños Calvo]

Hi Andreas.

Try with:

SELECT UpdateGeometrySRID('groads2', 'geom', 4326);

Regards,


El 16/06/2011 10:23, Andreas Forø Tollefsen escribió:
> Hi,
>
> I have merged 4 tables with line geometry. In total 1028110 rows.
> However, when i had unionized the tables, i realized that i had forgot
> to set the SRID for 2 of the tables.
> Hence, I now have a table where half of the roughly half a million
> rows have a SRID.
>
> I then tried to run the UpdateGeometrySRID, but something is wrong.
> Syntax seems correct according to manual:
> http://postgis.refractions.net/documentation/manual-svn/UpdateGeometrySRID.html
>
> <sql>
> SELECT UpdateGeometrySRID(groads2, geom, 4326);
> </sql>
>
> groads2 is my table, geom is the geometry column and the srid should
> be 4326 WGS84.
>
> However, when running the above query, i get this:
>
> ERROR:  column "groads2" does not exist
> LINE 3: SELECT UpdateGeometrySRID(groads2, geom, 4326);
>                                    ^
>
> ********** Error **********
>
> ERROR: column "groads2" does not exist
> SQL state: 42703
> Character: 99
>
> Any ideas?
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 

Sergio Baños Calvo

Jefe de desarrollos
Sistemas Abiertos de Información Geográfica, S.L. (SAIG S.L.)
Tlfno. móvil: 685005960
Tlfno. fijo: (+34) 954788876

E-mail: sbc at saig.es

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110616/bc9eceff/attachment.html>