Postgres Pro
Downloads
Home   >   mailing lists

Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4 - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4
Date
Msg-id 20060915093624.GD21235@a-kretschmer.de
Whole thread Raw
In response to Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4  (gould@embl.de)
List pgsql-sql
Tree view 
am  Fri, dem 15.09.2006, um 11:16:06 +0200 mailte gould@embl.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

pgsql-sql by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4
Next
From: Ragnar
Date:
Subject: Re: [HACKERS] lower() not working correctly...?