]> granicus.if.org Git - postgresql/commit
Add pg_partition_root to display top-most parent of a partition tree
authorMichael Paquier <michael@paquier.xyz>
Thu, 7 Feb 2019 23:56:14 +0000 (08:56 +0900)
committerMichael Paquier <michael@paquier.xyz>
Thu, 7 Feb 2019 23:56:14 +0000 (08:56 +0900)
commit3677a0b26bb2f3f72d16dc7fa6f34c305badacce
treea46ee2b807265d8f0c899c53f1bad3bebec67b34
parent34ea1ab7fd305afe1124a6e73ada0ebae04b6ebb
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.

Author: Michael Paquier
Reviewed-by: Álvaro Herrera, Amit Langote
Discussion: https://postgr.es/m/20181207014015.GP2407@paquier.xyz
doc/src/sgml/func.sgml
src/backend/utils/adt/partitionfuncs.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.dat
src/test/regress/expected/partition_info.out
src/test/regress/sql/partition_info.sql