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

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

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/