BUG #17058: Unable to create collation in version 13.

The Post Office <noreply@postgresql.org>

From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: developer@yamashi-ta.jp
Date: 2021-06-13T08:56:24Z
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      17058
Logged by:          Yasushi Yamashita
Email address:      developer@yamashi-ta.jp
PostgreSQL version: 13.3
Operating system:   Windows 10
Description:        

[PostgreSQL 13.3, compiled by Visual C++ build 1914, 64-bit]

postgres=# CREATE COLLATION public.ja_jp (LOCALE = 'Japanese_Japan.932');
ERROR:  could not get collation version for locale "Japanese_Japan.932":
error code 87


[PostgreSQL 12.7, compiled by Visual C++ build 1914, 64-bit]

postgres=# CREATE COLLATION public.ja_jp (LOCALE = 'Japanese_Japan.932');
CREATE COLLATION

postgres=# SELECT * FROM pg_collation WHERE collname = 'ja_jp';
  oid  | collname | collnamespace | collowner | collprovider |
collisdeterministic | collencoding |    collcollate     |     collctype     
| collversion
-------+----------+---------------+-----------+--------------+---------------------+--------------+--------------------+--------------------+-------------
 16394 | ja_jp    |          2200 |        10 | c            | t            
      |            6 | Japanese_Japan.932 | Japanese_Japan.932 |
(1 row)

Commits

  1. Back-patch "Tolerate version lookup failure for old style Windows locale names."

  2. Tolerate version lookup failure for old style Windows locale names.