Hi if they are polygon's, you can turn then into multi ST_Multi(geometry)
Returns the geometry as a MULTI* geometry. If the geometry is already a MULTI*, it is returned unchanged. SELECT ST_MULTI(wkb_geometry) FROM table; See if your postgis version have that function. best regards, Luigi Castro Cardeles 2009/6/3 Richard Greenwood <[email protected]> > I am having trouble inserting geometries into a table. The geometry > column has a constraint: > enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) = > 'MULTIPOLYGON'::text > OR wkb_geometry IS NULL); > > I am attempting to insert what I assume are polygons generated by > st_buffer() but they violate the constraint. If I pgsql2shp the > polygons out I can insert them into the table, but that's pretty ugly. > > Thanks, > -- > Richard Greenwood > [email protected] > www.greenwoodmap.com > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
