Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16671: "generated always as" is ignored when updating table through view - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16671: "generated always as" is ignored when updating table through view
Date
Msg-id 3634945.1602712174@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16671: "generated always as" is ignored when updating table through view  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16671: "generated always as" is ignored when updating table through view  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16671: "generated always as" is ignored when updating table through view
Next
From: Tom Lane
Date:
Subject: Re: BUG #16671: "generated always as" is ignored when updating table through view