[postgis-users] Violation of Check-Constraint »enforce_srid_punkte«

[Jan Saalbach]

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 <fire at dubmosphere.de> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>