Re: pg_partition_tree crashes for a non-defined relation

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_partition_tree crashes for a non-defined relation
Дата
Msg-id 20190301002204.GA1348@paquier.xyz
обсуждение исходный текст
Ответ на Re: pg_partition_tree crashes for a non-defined relation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: pg_partition_tree crashes for a non-defined relation
Список pgsql-hackers
On Thu, Feb 28, 2019 at 04:32:03PM -0300, Alvaro Herrera wrote:
> Yeah, looks good, please push.

Done for this part.

> I would opt for returning the empty set for legacy inheritance too.
>
> More generally, I think we should return empty for anything that's
> either not RELKIND_PARTITIONED_TABLE or has relispartition set.

I think that one option is to make the function return only the table
itself if it is not a partitioned table, which would be more
consistent with what pg_partition_root() does.

What I am writing next sounds perhaps a bit fancy, but in my opinion a
normal table is itself a partition tree, made of one single member:
itself.
--
Michael

Вложения

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

Предыдущее
От: Michael Banck
Дата:
Сообщение: Re: Online verification of checksums
Следующее
От: Ramanarayana
Дата:
Сообщение: Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated withwrong context