Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10

From: YasonTR <yasontr(at)protonmail(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10
Date: 2017-10-24 12:00:43
Message-ID: DzifLcHs-9wlp5kq6MPKTxu6zI8s5LhAEaVsrq_NRTuQTkw_EWrogrLgDhQ7i5W-cvaIPig0gH59FzBk7Lwr8FUvV7H0fLOYI8heueaoG1Y=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

The following (odd) construction worked in pgv9.x: "UPDATE my_table SET (my_col) = (some value)". This no longer works in v10. It gives the error "source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression". It looks like it only breaks when the column list just holds one single column.

Possibly related to:

- https://www.postgresql.org/message-id/8542.1479742008%40sss.pgh.pa.us

- https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=906bfcad7

Let me know if you need more information.

Thank you. Warm regards,

YasonTR

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Suderevsky 2017-10-24 13:11:58 Re: BUG #14863: wrong reltuples statistics after vacuum without analyze
Previous Message tschimail1 2017-10-24 09:20:10 BUG #14868: Postgres as Windows Service doesn't shutdown properly