[postgis-users] connection terminated with buffer(0.0)

[Andreas Laggner]

Hello,

i used buffer(the_geom, 0.0) several times to repair geometry and it 
works good. But now i have a dataset, where problems occur: Any time i 
try to repair with buffer the connection to postgresql is terminated. It 
seems to relate to one (or more) bad geometry. What can i do now?

My statement (the most simple one without attributes to minimize 
possible sources for errors):

create table gemeinden_rep();
select 
addgeometrycolumn('','gemeinden_rep','the_geom','31467','MULTIPOLYGON',2);
alter table gemeinden_rep drop constraint enforce_geotype_the_geom;
insert into gemeinden_rep
    select buffer(the_geom, 0.0)
    from gemeinden;


Thanks      Andreas



-- 

Dipl. Geoökologe Andreas Laggner
Institut für Ländliche Räume (LR)
Bundesforschungsanstalt für Landwirtschaft (FAL)

Institute of Rural Studies
Federal Agricultural Research Centre (FAL)

Bundesallee 50
D-38116 Braunschweig

Tel.: (+49) (0)531 596 5515
Fax: (+49) (0)531 596 5599
E-mail: andreas.laggner at fal.de
Homepage: http://www.lr.fal.de/