drop table parent cascade; drop table parent2 cascade; create table parent(i int); create table c1 (check (i > 0 and i <= 1)) inherits (parent); create table parent2(i int); create table c12 (check (i > 0 and i <= 1)) inherits (parent2); set copy_partitioning_cache_size = 1; copy parent from stdin with (partitioning); 1 \. copy parent2 from stdin with (partitioning); 1 \. -- all tuples went to parent ! select * from parent; -- is empty select * from parent2;