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

On Tue, 23 Mar 2021 at 02:43, Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
>
> 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
>

Thanks Justin.

Sorry, my mistake is that without checking prior discussion, i opened
a new thread. From next time, I will take care of this.

--
Thanks and Regards
Mahendra Singh Thalor
EnterpriseDB: http://www.enterprisedb.com