Re: BUG #16671: "generated always as" is ignored when updating table through view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16671: "generated always as" is ignored when updating table through view
Дата
Msg-id 3634945.1602712174@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16671: "generated always as" is ignored when updating table through view  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16671: "generated always as" is ignored when updating table through view  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> [ updating via a view fails to recalculate GENERATED columns ]

Yeah, that's surely a bug.  In fact, it's a regression, because
the test case works as-expected in v12.  Not sure where we broke it.

> I could be ignorant of some limitations that views have, but I have neither
> looked for them nor seen them in the documentation. I just assumed in good
> faith that updating rows through a view would be safe in simple cases. Is
> this a dangerous assumption?

Assuming that a dot-zero release is bug-free can be dangerous :-(

            regards, tom lane



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16671: "generated always as" is ignored when updating table through view
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16671: "generated always as" is ignored when updating table through view