<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Andreas.<br>
<br>
Try with:<br>
<br>
<font face="Courier New, Courier, monospace">SELECT
UpdateGeometrySRID('groads2', 'geom', 4326);</font><br>
<br>
Regards,<br>
<br>
<br>
El 16/06/2011 10:23, Andreas Forø Tollefsen escribió:
<blockquote
cite="mid:BANLkTikUF0RxAHkTnF-r4c8SSboJetsPZg@mail.gmail.com"
type="cite">
<pre wrap="">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:
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/documentation/manual-svn/UpdateGeometrySRID.html">http://postgis.refractions.net/documentation/manual-svn/UpdateGeometrySRID.html</a>
<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
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=ISO-8859-1">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 1.1.4 (Win32)">
<meta name="AUTHOR" content="Sergio Baños Calvo">
<meta name="CREATED" content="20050920;9300231">
<meta name="CHANGEDBY" content="Sergio Baños Calvo">
<meta name="CHANGED" content="20050922;8305312">
<style>
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<p style="margin-bottom: 0cm;">Sergio Baños Calvo<br>
<br>
Jefe
de desarrollos<br>
Sistemas Abiertos de Información Geográfica,
S.L. (SAIG S.L.)<br>
Tlfno. móvil: 685005960<br>
Tlfno. fijo: (+34) 954788876<br>
<br>
E-mail:
<a class="moz-txt-link-abbreviated" href="mailto:sbc@saig.es">sbc@saig.es</a></p>
</div>
</body>
</html>