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

From: Steve Atkins <steve(at)blighty(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: Failed to build any 5-way joins
Date: 2007-04-22 03:36:34
Message-ID: 55377E84-D7B7-4AA8-9F32-CFC5D5E2BC88@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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?

Cheers,
Steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message judexhuang 2007-04-22 03:39:50 Re: can't start tsearch2 in 8.2.4
Previous Message Arthaey Angosii 2007-04-22 01:31:57 Indirect access to data, given table name as a string