Re: BUG #3865: ERROR: failed to build any 8-way joins

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Oleg Kharin <ok(at)uvadrev(dot)udmnet(dot)ru>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3865: ERROR: failed to build any 8-way joins
Date: 2008-01-11 05:08:14
Message-ID: 7922.1200028094@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2008-01-11 06:58:09 (possible) bug with constraint exclusion
Previous Message Tom Lane 2008-01-11 03:48:17 Re: BUG #3860: xpath crashes backend when is querying xmlagg result