Hi, I'm a novice, but shouldn't it be something like this... ?
UPDATE table SET geom = ST_SetSRID(geom, 4326) Cheers James On 16 June 2011 09:23, Andreas Forø Tollefsen <[email protected]> wrote: > 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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
