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

[Nicolas Ribot]

> 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?
>

Hi,

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 ?

Nicolas