On 9 June 2018 at 04:57, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Phil Florent <philflorent@hotmail.com> writes:
>> explain analyze select * from v where v.k1 > date '2017-01-01';
>> ERREUR: XX000: did not find all requested child rels in append_rel_list
>> EMPLACEMENT : find_appinfos_by_relids, prepunion.c : 2643
>
> Reproduced here, thanks for the report! This is very timely since
> we were just in process of rewriting that code anyway ...
Yeah. Thanks for the report Phil.
It looks like this was 499be013de6, which was one of mine.
A more simple case to reproduce is:
drop table listp;
create table listp (a int, b int) partition by list(a);
create table listp1 partition of listp for values in (1);
select * from (select * from listp union all select * from listp) t where a = 1;
I'll look in more detail after sleeping.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services