[postgis-users] Using exteriorring

[Benoit Ogier]

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 "enfo 
rce_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 ?

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
};
-- 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 884 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050218/4c201082/attachment.bin>