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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
