Hi Yuzuko Hosoya,
Ignore my last message, I think this is also a legitimate scan on default
partition.
On Mon, Mar 4, 2019 at 10:29 PM Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com> wrote:
> Hi
>
> Patch work fine to me, but I have one test case where default partition
> still scanned.
>
> postgres=# explain select * from test1 where (id < 10) and true;
> QUERY PLAN
> -------------------------------------------------------------------
> Append (cost=0.00..55.98 rows=846 width=36)
> -> Seq Scan on test1_1 (cost=0.00..25.88 rows=423 width=36)
> Filter: (id < 10)
> -> Seq Scan on test1_def (cost=0.00..25.88 rows=423 width=36)
> Filter: (id < 10)
> (5 rows)
--
Ibrar Ahmed