[postgis-users] Transformation

[Thomas Zuberbuehler]

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