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