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
