pg_pathman
pg_pathman copied to clipboard
Prune partitions at runtime selecting from view
Problem description
Table partitioned by date_cln.
When I use condition
date_cln >= (select date_trunc('year', now() - interval '1 year'))
inside sql function or reqular SELECT - planner successfully prune archival partitions and RuntimeAppend node appears in execution plan.
When I use this condition inside view, then select - no RuntimeAppend node and archival partitions in plan
Is it bug or pg_pathman doesn't support partitioned tables inside views ?
Environment
select version();
PostgreSQL 9.6.12 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
select pathman_version();
1.5.4