Re: Incorrect explain output for updates/delete operations with returning-list on partitioned tables

2024-05-06 Thread David Rowley
On Tue, 7 May 2024 at 09:18, Tom Lane wrote: > > SAIKIRAN AVULA writes: > > I have been working on partitioned tables recently, and I have noticed > > something that doesn't seem correct with the EXPLAIN output of an > > update/delete query with a returning list. > > What do you think is not

Re: Incorrect explain output for updates/delete operations with returning-list on partitioned tables

2024-05-06 Thread Tom Lane
SAIKIRAN AVULA writes: > I have been working on partitioned tables recently, and I have noticed > something that doesn't seem correct with the EXPLAIN output of an > update/delete query with a returning list. What do you think is not right exactly? The output has to use some one of the

Incorrect explain output for updates/delete operations with returning-list on partitioned tables

2024-05-06 Thread SAIKIRAN AVULA
Hi PostgreSQL Community, I have been working on partitioned tables recently, and I have noticed something that doesn't seem correct with the EXPLAIN output of an update/delete query with a returning list. For example, consider two partitioned tables, "t1" and "t2," with partitions "t11," "t12,"