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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rad(at)killian(dot)email
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Subject: Re: BUG #16671: "generated always as" is ignored when updating table through view
Date: 2020-10-14 21:49:34
Message-ID: 3634945.1602712174@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-10-14 22:45:53 Re: BUG #16671: "generated always as" is ignored when updating table through view
Previous Message PG Bug reporting form 2020-10-14 20:30:55 BUG #16671: "generated always as" is ignored when updating table through view