Re: Table alias fun == incorrectly adding tables to join...

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Sean Chittenden <sean(at)chittenden(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Table alias fun == incorrectly adding tables to join...
Date: 2003-09-22 20:12:55
Message-ID: 1064261574.13486.174.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> NOTICE: adding missing FROM-clause entry for table "table_s1"
> NOTICE: adding missing FROM-clause entry for table "table_s2"

> and execution times explode, naturally. I don't know if the spec says
> this is the correct behavior or not, but I have a feeling its not and
> this is a bug.

This is a PostgreSQL extension to make it easier on those using the
database. In fact, it's the only way to currently write a delete using a
join.

In 7.4 you can disable this extension in postgresql.conf
(add_missing_from = false)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sean Chittenden 2003-09-22 20:13:59 Re: Table alias fun == incorrectly adding tables to join...
Previous Message Stephan Szabo 2003-09-22 20:01:14 Re: Table alias fun == incorrectly adding tables to join...