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

Поиск
Список
Период
Сортировка
От Alexander Pyhalov
Тема Re: foreign join error "variable not found in subplan target list"
Дата
Msg-id 80d1b0827ea8643e0163cd06b384b9d4@postgrespro.ru
обсуждение исходный текст
Ответ на 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"  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-bugs
Richard Guo писал 2022-08-10 08:28:
> 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
> thecolumns required for evaluating the local conditions when we
> consider
> EPQ paths with pathkeys? Something like attached.
> 
> Thanks
> Richard

Hi.
Why are we sure that epq_path can provide all vars from restrictinfo?
-- 
Best regards,
Alexander Pyhalov,
Postgres Professional



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

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