model-writtenrun 5960 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Erki Eessaar reported that PostgreSQL 14 deparsed named function parameters as positional references inside INSERT/SELECT in SQL-standard function bodies, while UPDATE retained names #1.
- Masahiko Sawada asked whether the regenerated function behaved differently #2, and Erki Eessaar confirmed equivalent execution but explained the inconsistent display and maintenance concerns when reordering parameters #3.
- Tom Lane traced the inconsistency to a missing parent namespace list in get_insert_query_def and supplied a fix with defensive checks in get_parameter #4; he explained that original parameter-reference spelling is not preserved and proposed limiting the fix to PostgreSQL 14 and later because earlier versions had no apparent visible consequences.
- Masahiko Sawada confirmed that the fix worked and supplied an additional regression test checking parameter names in the deparsed INSERT/SELECT #5.
- Tom Lane committed the unchanged code fix from #4 together with a simplified version of the test from #5 as a8d8445a7b, then confirmed it was pushed and thanked Sawada for the test, leaving no outstanding work in the thread #6.