[postgis-users] is it possible to dissolve boundaries in postgis?

[strk at refractions.net]

On Thu, May 04, 2006 at 05:41:41PM -0500, Nelson Guda wrote:
> Hi again,
> 
> I think I figured out how to dissolve boundaries from an archived  
> post.  However, now that the new table is created I need to know how  
> to "bless" the new geometry column.  I tried creating a new geometry  
> column and setting it equal to the newly created column, but it kept  
> giving me the error "enforce_geotype_wkb_geometry" and I couldn't  
> figure out a way around that.
> 
> Can anyone help with this?

That means that you have mixed-type geometries in your result.
Probably Polygon, MultiPolygon or GeometryCollection.

Check that out and maybe create a column for each type.

--strk;