[postgis-users] FW: Support in ST_ConvexHull syntax

[Sandro Santilli]

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 ;
);

--strk; 

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