On 9 June 2018 at 04:57, Tom Lane <t...@sss.pgh.pa.us> wrote: > Phil Florent <philflor...@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