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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rod(at)iol(dot)ie
Cc: "'PostgreSQL'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ERROR: Failed to build any 5-way joins
Date: 2007-04-21 22:41:03
Message-ID: 13342.1177195263@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2007-04-21 22:42:14 Re: large table problem
Previous Message Raymond O'Donnell 2007-04-21 22:20:31 ERROR: Failed to build any 5-way joins