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
-
Back-patch "Tolerate version lookup failure for old style Windows locale names."
- 6dcb185bfc38 13.4 landed
-
Tolerate version lookup failure for old style Windows locale names.
- 9f12a3b95dd5 14.0 cited