From: Richard Huxton <dev@archonet.com>
To: "Alessandro Depase" <alessandro.depase@libero.it>,
	"Peter Eisentraut" <peter_e@gmx.net>, <pgsql-sql@postgresql.org>
Subject: Re: failed to build any 5-way joins
Date: Tue, 16 Dec 2003 16:12:02 +0000
User-Agent: KMail/1.5
References: <001e01c3c3ca$4c0c4af0$0200a8c0@dedalus1>
	<200312161430.47119.peter_e@gmx.net>
	<000f01c3c3ea$1294efa0$0200a8c0@dedalus1>
In-Reply-To: <000f01c3c3ea$1294efa0$0200a8c0@dedalus1>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200312161612.02303.dev@archonet.com>

On Tuesday 16 December 2003 15:34, Alessandro Depase wrote:
>
People smarter than me are looking at this, but I can give you some quick 
feedback.
> Version? In my previous message I told that I'm using 7.4-1 on cygwin
> distribution. What other info do you need? How can I get them?

Are you sure it's 7.4.1? I wasn't aware that was publicly released yet.

> All I can think more than this is that I use a Windows XP O.S. and that I
> got this error both using JDBC and using pgAdmin III (but it seems to me
> that this is an error client-independent).

It certainly looks like a bug in PG itself, rather than client-related. I'd 
agree with your guess that it's somewhere in the query rewriter.

> The other problem, however, as I asked before, is: where can I find the
> documentation for this error (well, besides the source, of course)? are
> there known limits in joining tables?

I'm not aware of any particular limits on joins. There's even a genetic 
optimiser that kicks in when joins go above a certain number of tables 
(default of 12 but configurable in 7.4 iirc?).

-- 
  Richard Huxton
  Archonet Ltd