Christian Laursen wrote:
When I looked into it and tried it from psql, I got this notice:
NOTICE: adding missing FROM-clause entry for table "test2"
Now, I understand that postgresql is adding "test2" to the list of
tables, I am selecting from as it is missing. However the result
is quite different from what I expected.
Is there a way to change this behaviour to generate an error instead
of just a notice?
Yes - there is a setting in postgresql.conf that allows you to turn this
off (and I do so). The only reason it's left on is for compatibility
with older versions.
It's called "add_missing_from" or similar - see the "runtime
configuration" chapter of the manuals for details.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend