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

From Michael Paquier
Subject Re: pgsql: Add pg_partition_root to display top-most parent of apartition
Date
Msg-id 20190322035538.GO20192@paquier.xyz
Whole thread Raw
In response to Re: pgsql: Add pg_partition_root to display top-most parent of apartition  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [Suspect SPAM] Re: pgsql: Add pg_partition_root to displaytop-most parent of a partition
List pgsql-committers
On Fri, Mar 22, 2019 at 12:26:12AM -0300, Alvaro Herrera wrote:
> I noticed days ago that if you call pg_partition_root on the topmost
> partitioned table, the server crashes :-)

It's when you think that the thing is actually done that another issue
pops up.  The attached fixes the issue, I suggest to return the
top-most parent as result if the input is the top-most parent itself.
Returning NULL does not make sense as in this case the relation can be
part of a partition tree.
--
Michael

Attachment

pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pgsql: Add pg_partition_root to display top-most parent of apartition
Next
From: Amit Langote
Date:
Subject: Re: [Suspect SPAM] Re: pgsql: Add pg_partition_root to displaytop-most parent of a partition