Re: UNION ALL on partitioned tables won't use indices.

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: UNION ALL on partitioned tables won't use indices.
Дата
Msg-id 20140228024709.GA3355432@tornado.leadboat.com
обсуждение исходный текст
Ответ на Re: UNION ALL on partitioned tables won't use indices.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, Feb 27, 2014 at 05:47:16PM -0500, Tom Lane wrote:
> BTW, isn't the proposed change to the comments for adjust_appendrel_attrs
> just wrong?  If it's correct, why doesn't the Assert(!IsA(node, SubLink))
> therein fire?  (AFAICS, the existing comment is correct: we don't use
> this function until after expression preprocessing is complete.)

The comment change is accurate; expand_inherited_tables(), which precedes
subplan conversion, now calls adjust_appendrel_attrs().  I neglected to remove
the SubLink assert or test a scenario actually entailing a SubLink in
translated_vars.  Thanks for spotting the problem.

-- 
Noah Misch
EnterpriseDB                                 http://www.enterprisedb.com



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: tests for client programs
Следующее
От: Noah Misch
Дата:
Сообщение: Re: UNION ALL on partitioned tables won't use indices.