Re: UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Mahendra Singh Thalor <mahi6run(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c
Date: 2021-03-22 21:13:29
Message-ID: 20210322211328.GT4203@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Mar 22, 2021 at 02:10:49PM +0530, Mahendra Singh Thalor wrote:
> Hi Hackers,
>
> Commit 906bfcad7ba7c has improved handling for "UPDATE ... SET
> (column_list) = row_constructor", but it has broken in some cases where it
> was working prior to this commit.
> After this commit query “DO UPDATE SET (t1_col)” is giving an error which
> was working fine earlier.

See prior discussions:

https://www.postgresql.org/message-id/flat/20170719174507.GA19616%40telsasoft.com
https://www.postgresql.org/message-id/flat/CAMjNa7cDLzPcs0xnRpkvqmJ6Vb6G3EH8CYGp9ZBjXdpFfTz6dg(at)mail(dot)gmail(dot)com
https://www.postgresql.org/message-id/flat/87sh5rs74y(dot)fsf(at)news-spur(dot)riddles(dot)org(dot)uk
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commit&h=86182b18957b8f9e8045d55b137aeef7c9af9916

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhihong Yu 2021-03-22 21:36:38 Re: pg_upgrade failing for 200+ million Large Objects
Previous Message Thomas Munro 2021-03-22 21:07:07 Re: proposal - psql - use pager for \watch command