model-writtenrun 9265 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Peter Eisentraut proposed CREATE DATABASE LOCALE as a shortcut setting both LC_COLLATE and LC_CTYPE, aligning with existing tools and preparing for non-libc collation providers; the initial patch also made pg_dump emit the shortcut when both values match #1.
- FabrÃzio de Royes Mello requested test coverage, and discussion of where to place it led Alvaro Herrera to recommend src/bin/pg_dump/t/002_pg_dump.pl #2 #3 #4 #5.
- Heikki Linnakangas questioned whether LOCALE should also set lc_messages, lc_monetary, lc_numeric, and lc_time; Peter's revision retained the narrower scope, documented ALTER DATABASE ... SET for those settings, and added the requested test #6 #7.
- Fabien COELHO successfully built and tested the revision, requested a clearer conflicting-options diagnostic and simpler pg_dump conditions, and questioned whether emitting LOCALE justified losing compatibility with older restore targets #8.
- Peter incorporated the diagnostic and condition changes while retaining LOCALE output to support future ICU-related development; Fabien tested the final revision and marked it ready despite his remaining compatibility reservation #9 #10.
- The final patch landed unchanged as 06140c201b from #9, and Peter closed the thread by confirming the commit #11.