[postgis-users] Invalid geometry

[Travis Kirstine]

I'm having some problems with shapefiles dumped out of postgis using
the pgsql2shp utility.  I am creating a geometry union using the
upgis_cascadeunion function then exploding the multi features to
single part features

CREATE TABLE omnr_glcbp_geomunion AS SELECT
upgis_cascadeunion(the_geom) as the_geom from omnr_glcbp_watersheds;

CREATE TABLE omnr_glcbp_boundary AS SELECT ST_GeometryN(the_geom,
generate_series(1, ST_NumGeometries(the_geom))) AS the_geom FROM
omnr_glcbp_geomunion ;

I then checked that that the geometry was valid and a multipolygon and
everything looks fine.  When the data is dumped to a shp file I get a
error when opening the file with arcgis "Number of shapes does not
match number of table records".  Also when I check the shapefile with
ogrinfo it does not report the geometry (returns Unknown).  I thought
that upgis_cascadeunion might be causing the problem however I had the
same results when using the ST_Buffer(Collect(the_geom), 0) to
dissolve the polygons.
-- 
Travis K.

Toronto, Canada
------------------------------------------------------------
"She knows there's no success like failure
And that failure's no success at all."
-Bob Dylan-
------------------------------------------------------------