[postgis-users] buffer(the_geom, 0) crashes the database

[Stefan Zweig]

hi mark,

the file i have upload includes just a single query. it includes the geometry (a multipolygon of russia) that crashes with buffer(the_geom, 0) in wkt representation. so it is nothing more than select buffer(geomfromtext('MULTIPOLYGON(.....)',4326),0)
i think without having the actual coordinates of this MULTIPOLYGON it won't be possible to debug.

regards,
stefan

> -----Ursprüngliche Nachricht-----
> Von: "Mark Cave-Ayland" <mark.cave-ayland at siriusit.co.uk>
> Gesendet: 20.01.09 11:31:31
> An: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Betreff: Re: [postgis-users] buffer(the_geom, 0) crashes the database


> Stefan Zweig wrote:
> 
> > Hi list,
> > 
> > my postgis version is: "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS"
> > and the following query lets completely crash my postgre database:
> > 
> > i have pasted the whole query to this link. unfortunately it can only be download 10 times:
> > http://rapidshare.com/files/186468552/buffer.txt.html
> > 
> > i guess the error comes from the geos module.
> > 
> > regards,
> > stefan
> 
> 
> Hi Stefan,
> 
> The file seems awfully large; is what you have uploaded just a single 
> query or a complete table? If it's the complete table, then posting just 
> the SQL part may allow people to help you.
> 
> 
> ATB,
> 
> Mark.
> 
> -- 
> Mark Cave-Ayland
> Sirius Corporation - The Open Source Experts
> http://www.siriusit.co.uk
> T: +44 870 608 0063
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


__________________________________________________________________
Deutschlands größte Online-Videothek schenkt Ihnen 12.000 Videos!*
http://entertainment.web.de/de/entertainment/maxdome/index.html