missing FROM-clause
Hi guys,
I upgraded my PostgreSQL server (7.4 to 8.2) and now
all my reports refuse to run because the warning
"missing FROM-clause".
How can I disable it, just to run as the old version??
I have tried:
# set add_missing_from to false
but, without success!! :(
The warning is still there!!
Thanks in advance,
Marcelo Pereira
__________________________________________________
Fale com seus amigos de gra�a com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/
MaRCeLO PeReiRA wrote:
Hi guys,
I upgraded my PostgreSQL server (7.4 to 8.2) and now
all my reports refuse to run because the warning
"missing FROM-clause".How can I disable it, just to run as the old version??
I have tried:
# set add_missing_from to false
but, without success!! :(
set add_missing_from to true;
You can also change this in the bottom of the postgresql.conf file.
Then go through your code and fix the queries that require this.
--
Richard Huxton
Archonet Ltd