[postgis-users] FW: Support in ST_ConvexHull syntax
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:
-- shows what you're trying to insert:
ST_ConvexHull(ST_Collect(geom)) FROM splitbeam_point ;
() Free GIS & Flash consultant/developer
More information about the postgis-users