Re: Add pg_partition_root to get top-most parent of a partition tree
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>, Postgres hackers <pgsql-hackers@postgresql.org>
Date: 2019-02-06T10:14:38Z
Lists: pgsql-hackers
Attachments
- partition-root-v5.patch (text/x-diff) patch v5
On Wed, Feb 06, 2019 at 05:26:48PM +0900, Amit Langote wrote: > Some minor comments on v4: Thanks for the review. > +/* > + * Perform several checks on a relation on which is extracted some > + * information related to its partition tree. > > This is a bit unclear to me. How about: > > Checks if a given relation can be part of a partition tree Done as suggested. > Returns the top-most parent of the partition tree to which a given > relation belongs, or NULL if it's not (or cannot be) part of any partition > tree Fine for me as well. > Given that a couple (?) of other patches depend on this, maybe it'd be a > good idea to proceed with this. If you are happy with the version attached, I am fine to commit it. I think that we have the right semantics and the right test coverage for this patch. > Sorry that I kept this hanging too long by not sending these > comments sooner. No problem, don't worry. There are many patches hanging around. -- Michael
Commits
-
Add pg_partition_root to display top-most parent of a partition tree
- 3677a0b26bb2 12.0 landed
-
Tweak pg_partition_tree for undefined relations and unsupported relkinds
- cc53123bcc9d 12.0 cited