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
[email protected]
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: [email protected]
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
