Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault - Mailing list pgsql-bugs

From Stefan Kaltenbrunner
Subject Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Date
Msg-id 4AEB099A.4080804@kaltenbrunner.cc
Whole thread Raw
In response to Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
List pgsql-bugs
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>> uploaded a dump of the dataset here:
>> http://www.kaltenbrunner.cc/files/rand_gen_data.sql
>> and the query that causes the segfault:
>> http://www.kaltenbrunner.cc/files/rand_gen_query.sql
>
> [ scratches head... ]  Still no crash here, and I tried it on a couple
> different types of hardware.  What configure parameters are you using,
> and what non-default postgresql.conf settings?

this is 8.5a2 configured with ./configure --enable-cassert
--enable-debug and  just default settings(ie plain initdb with default
settings).
The OS is Debian Lenny/AMD64.


Stefan

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Next
From: "Jonathan Hayward"
Date:
Subject: BUG #5148: Email to pgsql-bugs@postgresql.org bounces: