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
