[postgis-users] Updating Geometry

Sandro Santilli strk at keybit.net
Fri Nov 11 01:22:31 PST 2011


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



More information about the postgis-users mailing list