| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Philip Hofstetter <phofstetter(at)sensational(dot)ch> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Bug or stupidity |
| Date: | 2004-10-23 15:20:51 |
| Message-ID: | 20041023081917.S53934@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2004-10-23 15:30:02 | Re: OID's |
| Previous Message | Eddy Macnaghten | 2004-10-23 14:42:20 | Re: OID's |