[postgis-users] error updating multipoint: violates check constraint enforce_geotype

Nicolas Ribot nicolas.ribot at gmail.com
Tue Jul 6 05:33:08 PDT 2010

> Hi everyone,
> I have a program that updates a table containing multipoints.
> Now, I have several columns with multipoints, but only one breaks with the
> following error:
> org.postgresql.util.PSQLException: ERROR: new row for relation "lidarpoints"
> violates check constraint "enforce_geotype_numtarclassidreflect"
> The code and setup for the other multipoint geometries is exactly the same,
> which is why I am surprised that it's not working for this one case. I feel
> I am overlooking something simple.
> My update sql is:
> "update lidarpoints set numtarclassidreflect =
> ST_UNION(numtarclassidreflect, ST_GeomFromEWKT('SRID=4326;MULTIPOINT(2 0
> -1436)')) where lidarpts_id = currentRowID;"
> Does anybody know anything about this?


What is the geographic type of the ST_UNION returned by your query ?
Can it be null, and no constraint allowing null geometries exists in the table ?


More information about the postgis-users mailing list