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

Поиск
Список
Период
Сортировка
От Rajkumar Raghuwanshi
Тема Getting "ERROR: did not find all requested child rels inappend_rel_list" when enable_partition_pruning is on
Дата
Msg-id CAKcux6mTNvUKn2GbJcbf5XW3JqZ90tUwAYwVxsOOEKWAqskP2A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Getting "ERROR: did not find all requested child rels inappend_rel_list" when enable_partition_pruning is on  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Memory leaks in BufFileOpenShared()
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: WAL prefetch