On 2017/02/28 12:29, Michael Paquier wrote: > On Tue, Feb 28, 2017 at 12:23 PM, Bruce Momjian <br...@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 -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers