[postgis-users] Updating Geometry

Asli Akarsakarya asliakar at yahoo.com
Fri Nov 11 01:29:21 PST 2011


 :) I found it, thank you. 


________________________________
From: Sandro Santilli <strk at keybit.net>
To: Asli Akarsakarya <asliakar at yahoo.com>
Cc: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Friday, November 11, 2011 11:22 AM
Subject: Re: [postgis-users] Updating Geometry

On Fri, Nov 11, 2011 at 01:15:28AM -0800, Asli Akarsakarya wrote:
> Thank you Sandro,
> 
> The way you suggested works fine. 
> 
> 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?
> 
> "enforce_srid_<Geometry_Column_Name>" is a restriction defined on the spatial table.  ("position" is the name of my column, sorry.)

check the definition of that restriction. You should find the srid 
there. it'll match the actual srid of your old geometry.


-- strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111111/1d5a68eb/attachment.html>


More information about the postgis-users mailing list