Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Apr 21, 2007, at 3:41 PM, Tom Lane wrote:

"Raymond O'Donnell" <rod@xxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux