[postgis-users] Updating Geometry

[Sandro Santilli]

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