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

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Table alias fun == incorrectly adding tables to join...
Дата
Msg-id 1064261574.13486.174.camel@jester
обсуждение исходный текст
Ответ на Table alias fun == incorrectly adding tables to join...  (Sean Chittenden <sean@chittenden.org>)
Список 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 =3D false)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Table alias fun == incorrectly adding tables to join...
Следующее
От: Sean Chittenden
Дата:
Сообщение: Re: Table alias fun == incorrectly adding tables to join...