Re: Bug or stupidity

On Sat, 23 Oct 2004, Philip Hofstetter wrote:

> > As for what's SQL standard, I think by a strict definition your query
> > shouldn't be allowed at all, referencing an undefined table.
>
> This is exactly what I think too. I mean: I know I made an error in my
> query. It would just have been easier to find if PostgreSQL actually had
> told me so (I'm not getting those NOTICEs from PHP...).
>
> If it's wrong, it should be disallowed, not made worse by assuming a
> completely wrong thing.

It's enabled in large part for backwards compatibility.  There's a runtime
option that controls the behavior (add_missing_from).