model-writtenrun 4361 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Peter Eisentraut proposed implementing SQL-standard COLLATE UNICODE using ICU's root locale, providing a convenient standard name alongside UCS_BASIC, and attached the initial implementation in #1.
- Jeff Davis questioned whether UCS_BASIC correctly sorted by code point in #3; Thomas Munro explained its UTF-8 restriction in #4, and Tom Lane saw little demand for extending it beyond a possible simple LATIN1 case in #6.
- Jeff Davis supported defining UNICODE even in builds without ICU, provided usage produced a clear error, in #3; Peter demonstrated the unsupported-feature error in #7, and Jeff accepted it in #9.
- Peter raised separate questions about pinning standard collations in pg_collation.dat and compatibility of the BCP 47 locale name 'und' in #8; the feature revision retained the initdb insertion and 'und' locale.
- Jeff requested making UNICODE encoding-independent and clarifying that UCS_BASIC matches C ordering specifically in UTF-8 in #9; Peter incorporated those changes in #10, which Jeff approved in #11.
- Peter committed #10 as 0d21d4b9bc, adding a regression test and catalog version bump, and announced the landing in #12.
- Jeff proposed using the root collation as ICU's default instead of inheriting the environment in #13, and Laurenz Albe supported that locale-agnostic default in #14.
- Peter argued that ICU should retain the same language as the still-required libc locale fields in #15, Joe Conway agreed in #16, and Jeff closed that discussion with no changes in #17.
- Daniel Verite demonstrated that UNICODE lacked collversion tracking in #18, noting that its definition had meanwhile moved into pg_collation.dat and asking whether to restore an INSERT or update the version afterward.
- Peter supplied an initdb UPDATE using pg_collation_actual_version in #19, following the existing pg_database initialization approach.
- The fix from #19 landed as e32701b8d2 with a comment adjustment and catalog version bump; Peter's final confirmation in #20 leaves both the feature and its version-tracking fix committed.