model-writtenrun 8022 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Michael Paul Killian reported that PostgreSQL 13 left stored generated-column values stale when updating their base columns through a view, while direct table updates worked correctly #1.
- Tom Lane confirmed that the example worked in PostgreSQL 12 and therefore represented a regression #2.
- Tom Lane bisected the regression to c6679e4fca, which optimized generated-column updates by relying on extraUpdatedCols to identify columns needing recomputation #3.
- Tom Lane connected the failure to his earlier concerns in thread #42346 and posted a patch moving extraUpdatedCols calculation into query rewriting, overwriting stored bitmap values and adding tests for generated columns through views #4.
- The thread ends with the patch submission #4, with no subsequent review shown; Tom Lane committed it unchanged the following day as ad77039fad, with backports through PostgreSQL 12 to address both view updates and outdated generated-column dependencies in stored rules.