Re: UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c - Mailing list pgsql-hackers

From Mahendra Singh Thalor
Subject Re: UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c
Date
Msg-id CAKYtNArqqQysuMX4ZQoN6haAvX-df-tWHuVSX7Mik9NRLqRagQ@mail.gmail.com
Whole thread Raw
In response to Re: UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
On Tue, 23 Mar 2021 at 02:43, Justin Pryzby <pryzby@telsasoft.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@mail.gmail.com
> https://www.postgresql.org/message-id/flat/87sh5rs74y.fsf@news-spur.riddles.org.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



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Handling of opckeytype / CREATE OPERATOR CLASS (bug?)
Next
From: Pavel Stehule
Date:
Subject: Re: proposal - psql - use pager for \watch command