[postgis-users] Updating Geometry

[Sandro Santilli]

On Thu, Nov 10, 2011 at 01:55:57PM -0800, Asli Akarsakarya wrote:
> 
> I am having trouble when attempting to update an existing geometry on a spatial table. The table stores 2D Point geometry, with the SRID 101. The update statement i am trying to use to update the geometry with the id 110 is as follows:
> 
> UPDATE <Table_Name> SET <Geometry_Column_Name> = GeometryFromText('POINT(44 31)', 101) WHERE <id_Column>=110
> 
> But I get an error that says the statement violates the "enforce_srid_position" restriction. Though the SRID's are the same.

Probably they aren't. Try:

 UPDATE <Table_Name> SET <Geometry_Coumn_Name> = GeometryFromText(
 'POINT(44 31)', ST_Srid(<Geometry_Column_Name>)) WHERE <id_Column>=110;

Then check what "enforce_srid_position" is
(doesn't sound like the correct name) using:

 \d <Table_Name>

--strk; 

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html