Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 21 Apr 2007 20:36:34 -0700
- Message-id: <55377E84-D7B7-4AA8-9F32-CFC5D5E2BC88(at)blighty(dot)com>
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 whenI 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
- Follow-Ups:
- Re: ERROR: Failed to build any 5-way joins
- From: Joshua D. Drake
- Re: ERROR: Failed to build any 5-way joins
- References:
- ERROR: Failed to build any 5-way joins
- From: Raymond O'Donnell
- Re: ERROR: Failed to build any 5-way joins
- From: Tom Lane
- ERROR: Failed to build any 5-way joins
- Prev by Date: Indirect access to data, given table name as a string
- Next by Date: Re: can't start tsearch2 in 8.2.4
- Previous by thread: Re: ERROR: Failed to build any 5-way joins
- Next by thread: Re: ERROR: Failed to build any 5-way joins
- Indexes: