Re: pgsql: Add pg_partition_root to display top-most parent of apartition

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pgsql: Add pg_partition_root to display top-most parent of apartition
Дата
Msg-id 20190322032612.GA323@alvherre.pgsql
обсуждение исходный текст
Ответ на pgsql: Add pg_partition_root to display top-most parent of apartition  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: pgsql: Add pg_partition_root to display top-most parent of apartition  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-committers
On 2019-Feb-08, Michael Paquier wrote:

> Add pg_partition_root to display top-most parent of a partition tree
> 
> This is useful when looking at partition trees with multiple layers, and
> combined with pg_partition_tree, it provides the possibility to show up
> an entire tree by just knowing one member at any level.

I noticed days ago that if you call pg_partition_root on the topmost
partitioned table, the server crashes :-)

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pgsql: Add pg_partition_root to display top-most parent of apartition