Thank you very much Mike. It works just the way you suggested.

Regards
Jan


Mike Toews schrieb:
On 7 October 2010 02:03, Jan Saalbach <[email protected]> wrote:
When I create the GeometryColumn with a real SRID instead and then try to
fill it with points, I get a violation error saying the "Check-Constraint
»enforce_srid_punkte«" is violated.

You need to also use ST_SetSRID(geom, srid) to give your point the
same SRID as the column definition. So ...

INSERT INTO table (example) VALUES
(ST_SetSRID(ST_makePoint(3441695.00,5975520.00,-7.56), 31467))

-Mike
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to