[postgis-users] Transformation

[Obe, Regina]

It sounds like your the_geom field has a  check contraint on it for a
different SRID other than 4326.  Did you use addgeometry to build the
the_geom field and did you specify 4326 as the SRID when you did that? 

I'm guessing that constraint was put in manually since the name that the
addgeometry function assigns would be usually enforce_srid_the_geom
unless a constraint with that name already existed for that table.

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Thomas Zuberbuehler
Sent: Monday, December 11, 2006 6:54 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Transformation

Hi

I have a problem. Following SQL Statement don't work, why?

UPDATE HikeRoute SET the_geom =
GetFromastext(Transform(SetSRID(force_2d(the_geom), 21781), 4326));

ERROR:  new row for relation "hikeroute" violates check constraint
"enforce_srid_the_geom1"

Who has a solution how I can do this?

Thank you.
Regards,
Thomas

--
Thomas Zuberbuehler
http://www.zubi.li
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.