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 3637295.1602715553@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #16671: "generated always as" is ignored when updating table through view  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #16671: "generated always as" is ignored when updating table through view  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I wrote:
> 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.

git bisect blames

c6679e4fca21d253ced84c51ac1a31c1b2aec72f is the first bad commit
commit c6679e4fca21d253ced84c51ac1a31c1b2aec72f
Author: Peter Eisentraut <peter@eisentraut.org>
Date:   Mon Feb 17 15:19:58 2020 +0100

    Optimize update of tables with generated columns

    When updating a table row with generated columns, only recompute those
    generated columns whose base columns have changed in this update and
    keep the rest unchanged.  This can result in a significant performance
    benefit.  The required information was already kept in
    RangeTblEntry.extraUpdatedCols; we just have to make use of it.

    Reviewed-by: Pavel Stehule <pavel.stehule@gmail.com>
    Discussion: https://www.postgresql.org/message-id/flat/b05e781a-fa16-6b52-6738-761181204567@2ndquadrant.com


            regards, tom lane



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

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