[postgis-users] error recovering multipolygones

[Christoph Schumacher]

----------------ursprüngliche Nachricht-----------------
Von: "Sandro Santilli" strk at keybit.net 
An: "PostGIS Users Discussion" 
Datum: Tue, 6 Mar 2012 15:03:07 +0100
-------------------------------------------------
 
 
> On Tue, Mar 06, 2012 at 02:36:13PM +0100, Christoph Schumacher wrote:
> 
>> I have a problem with recovery multipolygons from an *.backup file out of the 
>> pgadmin.
>> 
>> Due to an database error i had to backup the existing database with many 
>> multipolygones.
>> After restoring the database every multipolygon was broken out to
>> single polygones with their own entry in the database.
> 
> There's no possibility for MULTIPOLYGON objects to become POLYGON due to 
> pg_restore or
> postgis_restore. Maybe you don't remember what you had ?
> 
> --strk; 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net 
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 



I´m sure that i had multipolygone objects....

I don´t understand it by myself because the geometrie collum should be the same as it was in the original table ( why should there any converting?!).

But I have to admit that I have no chance to check this. The original dataset is lost :(

thanks a lot for answering, I think the only thing I can do is to recreate the multipolygones by hand. After this I´ll try the restore case again and post the behavior of the backup....

best wishes

christoph