X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 3B8979FB28C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Sep 2006 06:30:39 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 41497-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Sep 2006 06:30:34 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
	by postgresql.org (Postfix) with ESMTP id 1A8A99FB272
	for <pgsql-sql@postgresql.org>; Fri, 15 Sep 2006 06:30:33 -0300 (ADT)
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1GOA1Y-0002KL-ML
	for pgsql-sql@postgresql.org; Fri, 15 Sep 2006 11:30:16 +0200
Received: from pirus.securax.be ([213.16.46.130])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Fri, 15 Sep 2006 11:30:16 +0200
Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Fri, 15 Sep 2006 11:30:16 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: "Milen A. Radev" <milen@radev.net>
Subject: Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4
Date: Fri, 15 Sep 2006 12:29:54 +0300
Lines: 14
Message-ID: <eedrqi$nkv$1@sea.gmane.org>
References: <20060915111606.l3dwaqkxhz0gs0kw@webmail.embl.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@sea.gmane.org
X-Gmane-NNTP-Posting-Host: pirus.securax.be
User-Agent: Mozilla Thunderbird 1.5.0.5 (Windows/20060719)
In-Reply-To: <20060915111606.l3dwaqkxhz0gs0kw@webmail.embl.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.049 tagged_above=0 required=5 tests=AWL,
	SPF_HELO_PASS, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200609/108
X-Sequence-Number: 26319

gould@embl.de написа:
[...]
> Is there some query optimization config setting I can set in pgsql 8.1.4 to fix
> this problem rather than having to change  the queries in the code? I've read
> over the changes between pgsql 7 and pgsql 8 but nothing seems to stand out to
> me as referencing this problem. Anyone with more knowledge that can point me in
> the right direction?

Look here for "add_missing_from" -
http://www.postgresql.org/docs/8.1/static/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION


-- 
Milen A. Radev