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

[Benoît Andrieu]

Hi all,

I agree with the fact that the file is a bit too large... ^^

I have seen one thing :
there is a missing ) and a missing ; at the end of the query :

66.6869435)))',0) should be 66.6869435)))'),0);

But with the corrected query, postgre is crashing making an abortion of the windows service  !!!! You can see the detailed error 
below my message.

So I don't know...

Sorry !

Regards,

Benoît Andrieu
bea at ixsea.com
benoit.andrieu at gmail.com

---------------------------
Microsoft Visual C++ Runtime Library
---------------------------
Assertion failed!

Program: C:\PostgreSQL\bin\postgres.exe
File: ../../source/headers/geos/noding/SegmentString.h
Line: 175

Expression: pts->size() > 1

For information on how your program can cause an assertion
failure, see the Visual C++ documentation on asserts

(Press Retry to debug the application - JIT must be enabled)
---------------------------
Abort   Retry   Ignore
---------------------------

----- Original Message ----- 
From: "Mark Cave-Ayland" <mark.cave-ayland at siriusit.co.uk>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Tuesday, January 20, 2009 11:25 AM
Subject: 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