Tom Lane wrote: > [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: >> Of course not, it's not a bug - if this is a problem, it's a bug in >> Postgresql: > > If glibc 2.2.2 sorts that way in C locale, then glibc is broken. > But I assume you meant this is the behavior in some other locale. > > Postgres as such can cope just fine with non-C sort orders, but it > seems quite possible that the koi8 regression test sample outputs were > constructed using C-locale sort rules. Since the original complainant > merely asserted those tests were broken without defining what he meant > by broken, we're pretty much wasting our time speculating... > > regards, tom lane i'm really sorry!!! problem was because of glibc upgrade. where is no "ru_RU.KOI8-R" locale in glibc 2.2.2 and i changed it to "ru". the database was initdb'ed with former locale and thus PG was unable to use ru_RU.KOI8-R.... re-initdb just solved the problem sorry once again! ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
