X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6EE869DCDBD for ; Sun, 15 Jan 2006 17:54:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65152-08 for ; Sun, 15 Jan 2006 17:54:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 1753A9DCDAA for ; Sun, 15 Jan 2006 17:54:50 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k0FLsn5G014683 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sun, 15 Jan 2006 14:54:52 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k0FLsnNN030865; Sun, 15 Jan 2006 14:54:49 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k0FLsmAV030864; Sun, 15 Jan 2006 14:54:48 -0700 (MST) (envelope-from mfuhr) Date: Sun, 15 Jan 2006 14:54:48 -0700 From: Michael Fuhr To: "Dean Gibson (DB Administrator)" Cc: pgsql-sql Subject: Re: What does "merge-joinable join conditions" mean ???? Message-ID: <20060115215448.GA30809@winnie.fuhr.org> References: <43CAAFA6.6050001@ultimeth.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43CAAFA6.6050001@ultimeth.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.098 required=5 tests=[AWL=0.098] X-Spam-Score: 0.098 X-Spam-Level: X-Archive-Number: 200601/79 X-Sequence-Number: 23868 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-6 http://www.postgresql.org/docs/8.0/interactive/release-8-0-5.html -- Michael Fuhr