aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2019-02-08 08:56:14 +0900
committerMichael Paquier <michael@paquier.xyz>2019-02-08 08:56:14 +0900
commit3677a0b26bb2f3f72d16dc7fa6f34c305badacce (patch)
treea46ee2b807265d8f0c899c53f1bad3bebec67b34 /doc/src
parent34ea1ab7fd305afe1124a6e73ada0ebae04b6ebb (diff)
downloadpostgresql-3677a0b26bb2f3f72d16dc7fa6f34c305badacce.tar.gz
postgresql-3677a0b26bb2f3f72d16dc7fa6f34c305badacce.zip
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
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/func.sgml11
1 files changed, 11 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 4930ec17f62..86ff4e5c9e2 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -20274,6 +20274,17 @@ postgres=# SELECT * FROM pg_walfile_name_offset(pg_stop_backup());
their partitions, and so on.
</entry>
</row>
+ <row>
+ <entry>
+ <indexterm><primary>pg_partition_root</primary></indexterm>
+ <literal><function>pg_partition_root(<type>regclass</type>)</function></literal>
+ </entry>
+ <entry><type>regclass</type></entry>
+ <entry>
+ Return the top-most parent of a partition tree to which the given
+ relation belongs.
+ </entry>
+ </row>
</tbody>
</tgroup>
</table>