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

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: developer(at)yamashi-ta(dot)jp, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17058: Unable to create collation in version 13.
Date: 2021-06-13 20:33:05
Message-ID: CA+hUKGL+v4k4A-arnM-guofXBJh8ibR=CspP06dpis7gkzANtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jun 14, 2021 at 12:31 AM PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
> [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

Hmm. I fixed this in 14 with:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=9f12a3b95dd56c897f1aa3d756d8fb419e84a187

Perhaps I should back-patch that to 13. You can work around the
problem by using 'ja-JP' instead. That's a "BCP 47 tag", which the
Windows documentation recommends[1].

[1] https://docs.microsoft.com/en-us/cpp/c-runtime-library/locale-names-languages-and-country-region-strings?view=msvc-160

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergey Fedchenko 2021-06-14 11:17:24 Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events
Previous Message PG Bug reporting form 2021-06-13 08:56:24 BUG #17058: Unable to create collation in version 13.