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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
