Re: Bug or stupidity - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Bug or stupidity
Date
Msg-id 20041023081917.S53934@megazone.bigpanda.com
Whole thread Raw
In response to Re: Bug or stupidity  (Philip Hofstetter <phofstetter@sensational.ch>)
Responses Re: Bug or stupidity
List pgsql-general
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).


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Bug or stupidity
Next
From: Doug McNaught
Date:
Subject: Re: OID's