From: Tom Lane <tgl@sss.pgh.pa.us>
To: rad@killian.email
cc: pgsql-bugs@lists.postgresql.org,
        Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Subject: Re: BUG #16671: "generated always as" is ignored when updating table
 through view
In-reply-to: <16671-2fa55851859fb166@postgresql.org>
References: <16671-2fa55851859fb166@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Wed, 14 Oct 2020 20:30:55 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3634944.1602712174.1@sss.pgh.pa.us>
Date: Wed, 14 Oct 2020 17:49:34 -0400
Message-ID: <3634945.1602712174@sss.pgh.pa.us>
Precedence: bulk

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