I test the following command and works fine (it select only one partition) but I'm don't like to much the execute command:
execute 'DELETE FROM FAC_ITEM WHERE FCODDIST='''||DSTCOD||''' AND FSUCURS='||SUCCOD||'::integer AND FFECHAI='''||to_char(FECHAI,'yyyy-mm-dd')||''' AND FIMPNUM<>'||IMPNUM;
Is there any other workaround?
El mié, 25 nov 2020 a las 18:58, Tom Lane (<tgl@sss.pgh.pa.us>) escribió:
PG Bug reporting form <noreply@postgresql.org> writes: > If I execute: > select * FROM FAC_ITEM WHERE FCODDIST='' AND FSUCURS=1 AND > FFECHAI=current_date; > it use only one partition > but: > delete FROM FAC_ITEM WHERE FCODDIST='' AND FSUCURS=1 AND > FFECHAI=current_date; > scan all partitions
> Is there any regression?
No. There's work afoot to improve this, but it wasn't any better before.
