[postgis-users] FW: Support in ST_ConvexHull syntax

Sandro Santilli strk at keybit.net
Thu Oct 20 01:15:41 PDT 2011

On Wed, Oct 19, 2011 at 06:03:27PM +0000, Gery . wrote:

> mop=# insert into testone (geom) SELECT ST_ConvexHull(ST_Collect(geom)) as geom FROM splitbeam_point ;
> ERROR:  new row for relation "unaprueba" violates check constraint "enforce_geotype_geom"
> where could be the error? any hint is very grateful, thanks in advance

The error says that the "geom" field of "unaprueba" table is required
to be a geometry of a given type and you're trying to insert one of
a different type instead.

-- shows what type is expected by the table:
\d unaprueba

-- shows what you're trying to insert:
SELECT ST_GeometryType(
 ST_ConvexHull(ST_Collect(geom)) FROM splitbeam_point ;


  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

More information about the postgis-users mailing list