test6.sql

text/plain

Download

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;