On Fri, Jan 26, 2018 at 07:00:43PM +0900, Amit Langote wrote: > I wonder what pg_partition_tree_tables() should return when passed a table > that doesn't have partitions under it? Return a 1-member set containing > itself?
Yes. A table alone is itself part of a partition set, so the result should be made of only itself. > I also mean for tables that may inheritance children established > through plain old inheritance. There could be value in having a version dedicated to inheritance trees as well, true enough. As well as value in having something that shows both. Still let's not forget that partition sets are structured so as the parents have no data, so I see more value in having only partitions listed, without the INHERIT part. Opinions from others are of course welcome. -- Michael
signature.asc
Description: PGP signature
