Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4
Date: 2006-09-15 09:36:24
Message-ID: 20060915093624.GD21235@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

am Fri, dem 15.09.2006, um 11:16:06 +0200 mailte gould(at)embl(dot)de folgendes:
> Is there some query optimization config setting I can set in pgsql 8.1.4 to fix

Yes. 'add_missing_from = true' in the postgresql.conf

http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html

But, you should rewrite your SQL...

HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ragnar 2006-09-15 10:07:05 Re: [HACKERS] lower() not working correctly...?
Previous Message Milen A. Radev 2006-09-15 09:29:54 Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4