Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: pgsql: Add pg_partition_root to display top-most parent of apartition
Date
Msg-id 20190322032612.GA323@alvherre.pgsql
Whole thread Raw
In response to pgsql: Add pg_partition_root to display top-most parent of apartition  (Michael Paquier <michael@paquier.xyz>)
Responses Re: pgsql: Add pg_partition_root to display top-most parent of apartition
List pgsql-committers
Tree view 
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 by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: pgsql: Make heap TID a tiebreaker nbtree index column.
Next
From: Michael Paquier
Date:
Subject: Re: pgsql: Add pg_partition_root to display top-most parent of apartition