<html><body><div style="color:#000; background-color:#fff; font-family:tahoma, new york, times, serif;font-size:10pt"><div><span> :) I found it, thank you. </span></div><div><br></div><div style="font-size: 10pt; font-family: tahoma, 'new york', times, serif; "><div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "><font size="2" face="Arial"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Sandro Santilli <strk@keybit.net><br><b><span style="font-weight: bold;">To:</span></b> Asli Akarsakarya <asliakar@yahoo.com><br><b><span style="font-weight: bold;">Cc:</span></b> PostGIS Users Discussion <postgis-users@postgis.refractions.net><br><b><span style="font-weight: bold;">Sent:</span></b> Friday, November 11, 2011 11:22 AM<br><b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Updating Geometry<br></font><br>
On Fri, Nov 11, 2011 at 01:15:28AM -0800, Asli Akarsakarya wrote:<br>> Thank you Sandro,<br>> <br>> The way you suggested works fine. <br>> <br>> Though, I wonder what I cannot see. In the geometry_columns table, when I check the geometry's SRID, it is coded as 101. And this, I give to the "GeometryFromText" function. The only thing possible is, there's another coded srid in the geometry; which doesnt match the SRID in geometry_columns table. Any other suggestions?<br>> <br>> "enforce_srid_<Geometry_Column_Name>" is a restriction defined on the spatial table. ("position" is the name of my column, sorry.)<br><br>check the definition of that restriction. You should find the srid <br>there. it'll match the actual srid of your old geometry.<br><br><br>-- strk;<br><br> () Free GIS & Flash consultant/developer<br> /\
http://strk.keybit.net/services.html<br><br><br></div></div></div></body></html>