On Wed, Nov 27, 2019 at 10:38 AM Peter Eisentraut
Would you mind posting the full output of the above query (with <NULL>
showing) on a Windows system after running initdb with the -v2 patch,
so we can see how the collations look?
Sure, you can find attached the full output with ICU.
This is a resume to illustrate an issue with locale = 'C':
postgres=# CREATE COLLATION c_test (locale = 'C');
CREATE COLLATION
postgres=# select collname, collprovider, collencoding, collcollate, collctype, collversion from pg_collation ;
collname | collprovider | collencoding | collcollate | collctype | collversion
------------------------+--------------+--------------+------------------+------------------+-------------
default | d | -1 | | | <NULL>
C | c | -1 | C | C | <NULL>
POSIX | c | -1 | POSIX | POSIX | <NULL>
ucs_basic | c | 6 | C | C | <NULL>
und-x-icu | i | -1 | und | und | 153.97
[... resumed ...]
c_test | c | 6 | C | C |
(757 rows)