[postgis-users] Using exteriorring

[strk at refractions.net]

On Fri, Feb 18, 2005 at 05:04:19PM +0100, Benoit Ogier wrote:
> Hi, 
> 
> I would use the exteriorring function to get the exterior ring of multi 
> polygons, convert them to a single poly and store result in a new field 
> of my table "poly_test". 
> 
> using this sql command : 
> update nt_ownership_ew SET the_geom2 = exteriorring(the_geom) 
> 
> I get : 
> 
> ERROR:  new row for relation "poly_test" violates check constraint "enforce_geotype_the_geom2" 
> 
>  
> the_geom is MULTIPOLYGON kind, 
> the_geom2 is POLYGON kind, 
> 
> Questions : 
> - Is it the recommanded way to convert multi-polys to single polys ? 
> - If yes, where is the error ? 

You did everything the way you should, just a question, which
geometry type did you specify in the AddGeometryColumn() call 
to create the poly_test field ?

--strk;

> 
> Thanks, 
> 
> BO 
> 
> --  
> Benoît Ogier{ 
> Carte Blanche Conseil 
> 47, rue de Lancry 
> 75010 Paris 
> Tel : +33 1 42 41 21 21 
> Fax : +33 1 42 41 70 40 
> email : benoit.ogier at cbconseil.com 
> }; 
> --  
> 
> 

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users