Re: ERROR: Failed to build any 5-way joins - Mailing list pgsql-general

From Steve Atkins
Subject Re: ERROR: Failed to build any 5-way joins
Date
Msg-id 55377E84-D7B7-4AA8-9F32-CFC5D5E2BC88@blighty.com
Whole thread Raw
In response to Re: ERROR: Failed to build any 5-way joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ERROR: Failed to build any 5-way joins  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Apr 21, 2007, at 3:41 PM, Tom Lane wrote:

> "Raymond O'Donnell" <rod@iol.ie> writes:
>> I've just run into the above error (with the additional message "SQL
>> state XX000").
>> Funny thing is, when I change the join (between the views) either
>> to an
>> INNER JOIN or a RIGHT JOIN, the query works - it only goes belly-
>> up when
>> I try a LEFT JOIN.
>
> This sounds like a known bug in 8.2.x --- it's fixed for 8.2.4.  If
> you can still reproduce it with 8.2.4, please provide the test case.

Any guesses on the timeframe for packaging 8.2.4?

Cheers,
   Steve


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: PostgreSQL configuration
Next
From: "Joshua D. Drake"
Date:
Subject: Re: ERROR: Failed to build any 5-way joins