| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Christian <akattunga(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #16745: delete does not prune partitions on declarative partitioned table |
| Date: | 2020-11-25 22:41:50 |
| Message-ID: | CAKFQuwYnmqOWDm2HHXd2H0yFmaw2pYE-N=UdzDbYe4FH54X9oQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Nov 25, 2020 at 3:34 PM Christian <akattunga(at)gmail(dot)com> wrote:
> Ok so this is a known issue.
>
> 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?
>
Does:
EXECUTE sql USING DSTCOD, SUCCOD, etc...
sql = ... where FCODDIST=$1 AND FSUCURS=$2, etc...
work?
or
format(sql, DSTCOD, etc...)
sql = ... where FCODDIST=%L AND FSUCURS=%L, etc...
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian | 2020-11-25 23:46:14 | Re: BUG #16745: delete does not prune partitions on declarative partitioned table |
| Previous Message | Christian | 2020-11-25 22:04:41 | Re: BUG #16745: delete does not prune partitions on declarative partitioned table |