Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3865: ERROR: failed to build any 8-way joins - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3865: ERROR: failed to build any 8-way joins
Date
Msg-id 7922.1200028094@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #3865: ERROR: failed to build any 8-way joins  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #3865: ERROR: failed to build any 8-way joins  ("Oleg Kharin" <ok@uvadrev.udmnet.ru>)
List pgsql-bugs
Tree view 
I wrote:
> The most expedient way to fix it seems to be to make
> has_legal_joinclause consider, not the set of all relations anywhere
> in the query, but just members of the current initial_rels list.

8.2 patch is here, if you need it now:
http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3860: xpath crashes backend when is querying xmlagg result
Next
From: "Jan Arne Hansen"
Date:
Subject: BUG #3868: Unattended install fails