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

[Mark Cave-Ayland]

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