Markus Bertheau <twanger(at)bluetwanger(dot)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(at)rh1 tgl]$ cat ru_data
root
root
[tgl(at)rh1 tgl]$ sort -u ru_data
root
[tgl(at)rh1 tgl]$ LC_ALL=ru_RU.KOI8-R sort -u ru_data
root
[tgl(at)rh1 tgl]$
(The above is on an RHL 8.0 platform.)
regards, tom lane