Re: ERROR: Failed to build any 5-way joins - Mailing list pgsql-general

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

            regards, tom lane