Re: join pushdown and issue with foreign update

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: join pushdown and issue with foreign update
Дата
Msg-id
2845636.1622571541@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Amit Langote <amitlangote09@gmail.com>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Amit Langote <amitlangote09@gmail.com>
Re: join pushdown and issue with foreign update Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: join pushdown and issue with foreign update Amit Langote <amitlangote09@gmail.com>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Alexander Pyhalov  writes:
> What about the following patch?

ISTM that using a specific rowtype rather than RECORD would be
quite disastrous from the standpoint of bloating the number of
distinct resjunk columns we need for a partition tree with a
lot of children.  Maybe we'll have to go that way, but it seems
like an absolute last resort.

I think a preferable fix involves making sure that the correct
record-type typmod is propagated to record_in in this context.
Alternatively, maybe we could insert the foreign table's rowtype
during execution of the input operation, without touching the
plan as such.

Could we start by creating a test case that doesn't involve
uncommittable hacks to the source code?

			regards, tom lane


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Alexander Pyhalov
Дата:
FAQ