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
Date: Wed, 14 Oct 2020 17:49:34 -0400
Message-ID: <3634945.1602712174@sss.pgh.pa.us> (raw)
In-Reply-To: <16671-2fa55851859fb166@postgresql.org>
References: <16671-2fa55851859fb166@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, rad@killian.email, peter.eisentraut@2ndquadrant.com
Subject: Re: BUG #16671: "generated always as" is ignored when updating table through view
In-Reply-To: <3634945.1602712174@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox