Horton

Re: 'update returning *' returns 0 columns instead of empty row with 2 columns when (i) no rows updated and (ii) when applied to a partitioned table with sub-partition

Amit Langote <amitlangote09@gmail.com>

View thread View on postgr.es
From: Amit Langote <amitlangote09@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Petr Fedorov <petr.fedorov@phystech.edu>, PostgreSQL mailing lists <pgsql-bugs@postgresql.org>
Date: 2019-02-22T17:55:32Z
Lists: pgsql-bugs 
On Sat, Feb 23, 2019 at 2:26 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> writes:
> > On 2019/02/22 13:43, Tom Lane wrote:
> >> I'm too tired to work on that anymore today, do you want to run
> >> with it?
>
> > Sure, see attached a patch.
>
> OK, I prettified this a bit and pushed it.

Thank you.

Regards,
Amit

Commits

  1. Fix plan created for inherited UPDATE/DELETE with all tables excluded.