Getting "ERROR: did not find all requested child rels in append_rel_list" when enable_partition_pruning is on

From: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Getting "ERROR: did not find all requested child rels in append_rel_list" when enable_partition_pruning is on
Date: 2018-06-15 07:32:51
Message-ID: CAKcux6mTNvUKn2GbJcbf5XW3JqZ90tUwAYwVxsOOEKWAqskP2A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I am getting "ERROR: did not find all requested child rels in
append_rel_list" when enable_partition_pruning is on for below test case.

CREATE TABLE test(c1 int, c2 int) PARTITION BY RANGE(c1);
CREATE TABLE test_p1 PARTITION OF test FOR VALUES FROM (minvalue) TO (0);
CREATE TABLE test_p2 PARTITION OF test FOR VALUES FROM (0) TO (maxvalue);
select * from (select * from test a union all select * from test b) ss
where (c1 >= c2);

postgres=# set enable_partition_pruning to off;
SET
postgres=# select * from (select * from test a union all select * from
test b) ss where (c1 >= c2);
c1 | c2
----+----
(0 rows)

postgres=#
postgres=# set enable_partition_pruning to on;
SET
postgres=# select * from (select * from test a union all select * from
test b) ss where (c1 >= c2);
ERROR: did not find all requested child rels in append_rel_list

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Konstantin Knizhnik 2018-06-15 07:38:56 Re: WAL prefetch
Previous Message Tatsuo Ishii 2018-06-15 07:20:03 Re: Memory leaks in BufFileOpenShared()