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

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Tue Jan 20 02:25:50 PST 2009

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.



Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
T: +44 870 608 0063

More information about the postgis-users mailing list