model-writtenrun 1257 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Swirl Smog Dowry reported that PostgreSQL 18 could deparse a grouped view using LEFT JOIN USING over mismatched integer types into SQL that failed to reload, creating a pg_dump restore hazard #1.
- Tom Lane traced the regression to the introduction of the grouping RTE and identified premature join-alias flattening #2; his initial patch constructs RTE_GROUP before flattening expressions for comparison, although existing check-world tests did not expose the bug #3.
- Richard Guo endorsed retaining original GROUP BY expressions in the parse tree and leaving alias flattening to the planner, then resubmitted Tom's unchanged parser fix with a regression test for view deparsing #4.
- Richard questioned backpatch safety and explained that existing affected views would require recreation #5; Tom supported backpatching because the affected cases were already broken and saw no way to repair their stored definitions automatically #6.
- Tom committed the final submission #4 as c2c1962a64, with only rebasing and test line wrapping, and backpatched through PostgreSQL 18; his announcement narrowed the failure to LEFT JOIN USING with a grouped column requiring coercion on the left side #7.
- Richard's closing acknowledgment left the fix landed with no further patch work pending, while previously created affected views still needed recreation from their original SQL #8 #5.