Re: [HACKERS] PG10b2: column-list UPDATE syntax fails with single column

2017-07-19 Thread Tom Lane
Justin Pryzby writes: > ts=# begin; UPDATE eric_enodeb_201707 SET > (pmhdelayvarbest50pct,pmlicconnecteduserstimecong)=(0,0) ; > BEGIN > UPDATE 3 > ts=# begin; UPDATE eric_enodeb_201707 SET (pmhdelayvarbest50pct)=(0) ; > BEGIN > ERROR: source for a multiple-column UPDATE item must be a sub-SELEC

[HACKERS] PG10b2: column-list UPDATE syntax fails with single column

2017-07-19 Thread Justin Pryzby
In testing our application with PG10beta2, I discovered that our use of UPDATE broke, apparently by this commit |commit 906bfcad7ba7cb3863fe0e2a7810be8e3cd84fbd |Author: Tom Lane |Date: Tue Nov 22 15:19:57 2016 -0500 | |Improve handling of "UPDATE ... SET (column_list) = row_constructor".