Re: foreign join error "variable not found in subplan target list"

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: foreign join error "variable not found in subplan target list"
Дата
Msg-id CAMbWs49bW4i06Daf8eb1+tsbJVymA4U-3v6rRoNvqKaJSm459Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: foreign join error "variable not found in subplan target list"  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: foreign join error "variable not found in subplan target list"  (Alexander Pyhalov <a.pyhalov@postgrespro.ru>)
Re: foreign join error "variable not found in subplan target list"  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Список pgsql-bugs
Дерево обсуждения

On Wed, Aug 10, 2022 at 10:15 AM Richard Guo <guofenglinux@gmail.com> wrote:
Currently the outer_plan used in postgresGetForeignPlan() can only be
'Join' or 'Sort + Join'. I'm wondering whether we can take this
knowledge into consideration when we fix the outer_plan's tlist, to also
fix the Join's tlist if it is below the Sort node.

Alternatively, how about we include in the EPQ path's pathtarget the
columns required for evaluating the local conditions when we consider
EPQ paths with pathkeys? Something like attached.

Thanks
Richard
Вложения

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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: BUG #17574: Attaching an invalid index to partition head make head index invalid forever
Следующее
От: Alexander Pyhalov
Дата:
Сообщение: Re: foreign join error "variable not found in subplan target list"