model-writtenrun 7078 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Noah Misch proposed assertions to detect potential catalog self-deadlocks after a severe, unreleased bug demonstrated how conditional catalog reads could occur while holding exclusive catalog buffer locks #1.
- The patch checks safety before cache lookups and exempts four unique catalog indexes containing text columns, because their collation lookups cannot cause relcache builds to read those same indexes; a regression test verifies the exemption list #1.
- Noah invited opinions on those exemptions and separately identified a possible out-of-memory failure involving TYPEOID cache initialization outside a transaction, which the patch accommodates without fixing the underlying concern #1.
- Noah committed the sole submission on April 17, 2025, retaining its implementation and tests with light comment edits in catcache.c #1 f4ece891fc.
- The supplied thread ends with the initial proposal and contains no review replies or resolution of the separate TYPEOID concern; the attached assertion patch subsequently landed #1 f4ece891fc.