RE: partition pruning only works for select but update

We have other application depend on V13, possible to backport code changes to V13 as https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=86dc90056dfdbd9d1b891718d2e5614e3e432f35 Thanks, James -Original Message- From: Tom Lane Sent: Tuesday, June 28, 2022 9:30 PM To: James P

Re: partition pruning only works for select but update

On Fri, Jul 01, 2022 at 08:30:40AM +, James Pang (chaolpan) wrote: > We have other application depend on V13, possible to backport code changes to > V13 as > https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=86dc90056dfdbd9d1b891718d2e5614e3e432f35 Do you mean that the other appl

Re: partition pruning only works for select but update

Justin Pryzby writes: > On Fri, Jul 01, 2022 at 08:30:40AM +, James Pang (chaolpan) wrote: >> We have other application depend on V13, possible to backport code changes >> to V13 as >> https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=86dc90056dfdbd9d1b891718d2e5614e3e432f35 > I

RE: partition pruning only works for select but update

Thanks for your quick response, yes, pretty complicated logical replication between databases for our system, the logical replication tool just support V13 until now and it take long time for this vendor to support V14.We just migrate from Oracle to Postgres, a lot of partition tables and