Postgres Pro
Downloads
Home   >   mailing lists

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 4AEA85DD.6010808@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
Tree view 
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>> I can easily reproduce the segfault on 8.4 and 8.5a2:
>
> Doesn't crash here ... could we see the specific test data being used,
> please?

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


Stefan

pgsql-bugs by date:

Previous
From: Greg Stark
Date:
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Next
From: "hx.li"
Date:
Subject: Re: BUG #5147: DBA can not access view