model-writtenrun 4999 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Alexander Korolev reported that an unqualified CTID subquery failed alone but executed inside DELETE in #1; David G. Johnston explained outer-query column resolution in #2, and Tom Lane explained that joins omit system columns while qualified references remain available in #3.
- David questioned why the error did not report ambiguity in #4, and Tom distinguished inaccessible columns from accessible ambiguous names in #5; Alexander supplied a SELECT-versus-DELETE example in #6, which David discussed as a consequence of the correlated subquery in #7.
- After a ten-month gap, Bruce Momjian posted an experimental wording patch and regression results in #8, showing that some cases needed qualification, others needed LATERAL, and some UPDATE/DELETE references remained illegal.
- Tom rejected unconditional qualification advice and proposed separating factual DETAIL from actionable HINT in #9; Bruce clarified the need to distinguish the different causes in #11.
- Tom implemented namespace-flag checks for LATERAL and qualification hints in #12, also simplifying nested error-reporting expressions, and Bruce endorsed the result in #13.
- Alvaro Herrera tested the patch and questioned stopping at the first inaccessible exact match in #14; Tom responded with #15, preserving the earlier hints patch and adding separate exact-match tracking, revised fuzzy matching, and plural diagnostics.
- Tom combined both patches from #15 without substantive edits into 56d0ed3b75 and announced the push in #16, completing the diagnostic improvements without changing the original query semantics.