Postgres Pro
Downloads
Home   >   mailing lists

Re: Add pg_partition_root to get top-most parent of a partition tree - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Add pg_partition_root to get top-most parent of a partition tree
Date
Msg-id 20181207014859.auk6hmgsdqwuqos5@alvherre.pgsql
Whole thread Raw
In response to Add pg_partition_root to get top-most parent of a partition tree  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Add pg_partition_root to get top-most parent of a partition tree  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view 
I think adding a pg_partition_root() call to as many pg_partition_tree
tests as you modified is overkill ... OTOH I'd have one test that
invokes pg_partition_tree(pg_partition_root(some-partition)) to verify
that starting from any point in the tree you get the whole tree.

I haven't actually tried to write a query that obtains a tree of
constraints using this, mind ...

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Add pg_partition_root to get top-most parent of a partition tree
Next
From: Michael Paquier
Date:
Subject: Re: Add pg_partition_root to get top-most parent of a partition tree