pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17058: Unable to create collation in version 13.
3+ messages / 2 participants
[nested] [flat]
Commits from this thread:
2021-06-22 6dcb185bfc Back-patch "Tolerate version lookup failure for old style Windows locale names."
* BUG #17058: Unable to create collation in version 13.
@ 2021-06-13 08:56 PG Bug reporting form <noreply@postgresql.org>
2021-06-13 20:33 ` Re: BUG #17058: Unable to create collation in version 13. Thomas Munro <thomas.munro@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2021-06-13 08:56 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: developer@yamashi-ta.jp
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17058: Unable to create collation in version 13.
2021-06-13 08:56 BUG #17058: Unable to create collation in version 13. PG Bug reporting form <noreply@postgresql.org>
@ 2021-06-13 20:33 ` Thomas Munro <thomas.munro@gmail.com>
2021-06-22 01:30 ` Re: BUG #17058: Unable to create collation in version 13. Thomas Munro <thomas.munro@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Thomas Munro @ 2021-06-13 20:33 UTC (permalink / raw)
To: developer@yamashi-ta.jp, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Mon, Jun 14, 2021 at 12:31 AM PG Bug reporting form
<noreply@postgresql.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=9f12a3b95dd56c897f1aa3d756d8fb419e84a...
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-str...
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17058: Unable to create collation in version 13.
2021-06-13 08:56 BUG #17058: Unable to create collation in version 13. PG Bug reporting form <noreply@postgresql.org>
2021-06-13 20:33 ` Re: BUG #17058: Unable to create collation in version 13. Thomas Munro <thomas.munro@gmail.com>
@ 2021-06-22 01:30 ` Thomas Munro <thomas.munro@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Thomas Munro @ 2021-06-22 01:30 UTC (permalink / raw)
To: developer@yamashi-ta.jp, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Mon, Jun 14, 2021 at 8:33 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> 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].
Done.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-06-22 01:30 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-13 08:56 BUG #17058: Unable to create collation in version 13. PG Bug reporting form <noreply@postgresql.org>
2021-06-13 20:33 ` Thomas Munro <thomas.munro@gmail.com>
2021-06-22 01:30 ` Thomas Munro <thomas.munro@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox