Skip site navigation (1) Skip section navigation (2)

Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Bernt M(dot) Johnsen" <Bernt(dot)Johnsen(at)Sun(dot)COM>, Euler Taveira de Oliveira <euler(at)timbira(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault
Date: 2009-10-30 15:43:22
Message-ID: 4AEB099A.4080804@kaltenbrunner.cc (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Stefan KaltenbrunnerDate: 2009-10-30 17:13:41
Subject: Re: BUG #5148: Email to pgsql-bugs@postgresql.org bounces:
Previous:From: Tom LaneDate: 2009-10-30 15:34:03
Subject: Re: BUG #5145: Complex query with lots of LEFT JOIN causes segfault

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group