On 2017/02/28 12:29, Michael Paquier wrote:
> On Tue, Feb 28, 2017 at 12:23 PM, Bruce Momjian <bruce@momjian.us> wrote:
>> I am a little confused by the above. Is a partitioned table the parent
>> or the children? Reading the code it seems it is the parent, which
>> explains why it works. Can I clarify that?
>
> As I understand things, a partitioned table is a parent relation that
> exists only to link to its child portions, holding as well the
> definitions linking to each partition.
Yes. As I mentioned in my previous email, data inserted into the
partitioned table is routed to its partitions. A partition may be itself
a partitioned table, so the routing continues until we find a leaf
partition. All the partitioned tables in this chain leading to the leaf
partition are RELKIND_PARTITIONED_TABLE ('P') relations and only the leaf
tables are RELKIND_RELATION tables.
Thanks,
Amit