From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Getting "ERROR: did not find all requested child rels in append_rel_list" when enable_partition_pruning is on |
Date: | 2018-06-15 07:41:32 |
Message-ID: | f354c369-7067-e938-66b9-3f0e5a2ffb4f@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2018/06/15 16:32, Rajkumar Raghuwanshi wrote:
> 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 for the report. This appears to be the same problem as one being
discussed on the following thread where David Rowley even seems to have
posted a patch as a fix for this issue:
Thanks,
Amit
From | Date | Subject | |
---|---|---|---|
Next Message | Raphael Medaer | 2018-06-15 07:45:59 | Re: Attempt to fix inheritance limitations: unique and foreign key constraints |
Previous Message | Konstantin Knizhnik | 2018-06-15 07:38:56 | Re: WAL prefetch |