From: Michael Fuhr <mike@fuhr.org>
To: Dean Gibson (DB Administrator) <postgresql4@ultimeth.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: What does "merge-joinable join conditions" mean ????
Date: Sun, 15 Jan 2006 14:54:48 -0700
Message-ID: <20060115215448.GA30809@winnie.fuhr.org> (raw)
In-Reply-To: <43CAAFA6.6050001@ultimeth.com>
References: <43CAAFA6.6050001@ultimeth.com>
On Sun, Jan 15, 2006 at 12:25:10PM -0800, Dean Gibson (DB Administrator) wrote:
> I have a FULL JOIN between two simple tables, and am getting the message
> " Query failed: ERROR: FULL JOIN is only supported with merge-joinable
> join conditions"
>
> I'd be glad to fix this in my query if I knew what the #@!! it meant.
What's the query?
> Using 8.0.4 on FC1; willing to upgrade (PostgreSQL, not FC1) IF it
> would fix the problem.
The 8.0.5 Release Notes have the following item, but without seeing
your query it's hard to know whether this fix is relevant to your
problem (the fix mentions RIGHT JOIN; your error says FULL JOIN):
* Fix longstanding planning error for outer joins
This bug sometimes caused a bogus error "RIGHT JOIN is only
supported with merge-joinable join conditions".
Consider upgrading in any case. 8.0.6 is the latest in the 8.0
branch; see the Release Notes for a summary of fixes since 8.0.4:
http://www.postgresql.org/docs/8.0/interactive/release.html#RELEASE-8-0-6http://www.postgresql.org/docs/8.0/interactive/release-8-0-5.html
--
Michael Fuhr
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: mike@fuhr.org, postgresql4@ultimeth.com
Subject: Re: What does "merge-joinable join conditions" mean ????
In-Reply-To: <20060115215448.GA30809@winnie.fuhr.org>
* 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