Re: reproducible bug in I don't know what component - Mailing list pgsql-bugs

Markus Bertheau <twanger@bluetwanger.de> writes:
> Do the following in an installation initdb'd in ru_RU.KOI8-R (It doesn't
> happen if you initdb'd with UTF-8).

If this is a bug, it's a bug in the ru_RU.KOI8-R locale definition.
You can prove that the locale considers the strings equal without
Postgres at all:

[tgl@rh1 tgl]$ cat ru_data
root
root
ŜÅçÅÝÅçÅ£îŒ
ŜÅÅÇÅçÅ¥î‹
[tgl@rh1 tgl]$ sort -u ru_data
root
ŜÅçÅÝÅçÅ£îŒ
ŜÅÅÇÅçÅ¥î‹
[tgl@rh1 tgl]$ LC_ALL=ru_RU.KOI8-R  sort -u ru_data
root
ŜÅçÅÝÅçÅ£îŒ
[tgl@rh1 tgl]$

(The above is on an RHL 8.0 platform.)

            regards, tom lane