Re: ERROR: Failed to build any 5-way joins

Steve Atkins wrote:
>
> On Apr 21, 2007, at 3:41 PM, Tom Lane wrote:
>
>> "Raymond O'Donnell" <rod(at)iol(dot)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?

ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/v8.2.4

>
> Cheers,
> Steve
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/