[BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10

Поиск
Список
Период
Сортировка
От YasonTR
Тема [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10
Дата
Msg-id DzifLcHs-9wlp5kq6MPKTxu6zI8s5LhAEaVsrq_NRTuQTkw_EWrogrLgDhQ7i5W-cvaIPig0gH59FzBk7Lwr8FUvV7H0fLOYI8heueaoG1Y=@protonmail.com
обсуждение исходный текст
Ответы Re: [BUGS] Possible regression in 'UPDATE ... SET () = ' with just one single column/row value since v10
Список 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:


Let me know if you need more information.

Thank you. Warm regards,

YasonTR

В списке pgsql-bugs по дате отправления:

Предыдущее
От: tschimail1@gmail.com
Дата:
Сообщение: [BUGS] BUG #14868: Postgres as Windows Service doesn't shutdown properly
Следующее
От: Pavel Suderevsky
Дата:
Сообщение: Re: [BUGS] BUG #14863: wrong reltuples statistics after vacuum without analyze