[postgis-users] casting a geometry

[Richard Greenwood]

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
richard.greenwood at gmail.com
www.greenwoodmap.com