Re: Error with views containing sub-queries with distinct

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Error with views containing sub-queries with distinct
Дата
Msg-id 29007.1066454230@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Error with views containing sub-queries with distinct  ("Sean P. Thomas" <spt@ulanji.com>)
Список pgsql-hackers
"Sean P. Thomas" <spt@ulanji.com> writes:
> I get:
> JOIN qualification may not refer to other relations

Problem confirmed here, will look into it.  I have a feeling this is a
bad side-effect of this patch:

2003-10-13 19:48  tgl
* src/backend/optimizer/prep/prepjointree.c: pull_up_subqueries()should copy the subquery before starting to modify it.
  Not surewhy I'd thought it would be a good idea to do differently way backwhen, but Greg Stark exposed the folly of
doingso ...
 

but I don't see why as yet.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum thoughts
Следующее
От: Jean-Paul ARGUDO
Дата:
Сообщение: Re: Mapping Oracle types to PostgreSQL types