From: Richard Huxton <dev@archonet.com>
To: Alessandro Depase <alessandro.depase@libero.it>
To: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: failed to build any 5-way joins
Date: Tue, 16 Dec 2003 16:12:02 +0000
Message-ID: <200312161612.02303.dev@archonet.com> (raw)
In-Reply-To: <000f01c3c3ea$1294efa0$0200a8c0@dedalus1>
References: <001e01c3c3ca$4c0c4af0$0200a8c0@dedalus1>
<200312161430.47119.peter_e@gmx.net>
<000f01c3c3ea$1294efa0$0200a8c0@dedalus1>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, alessandro.depase@libero.it, peter_e@gmx.net
Subject: Re: failed to build any 5-way joins
In-Reply-To: <200312161612.02303.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox