"Pavel Stehule" <pavel.stehule@xxxxxxxxx> writes: > On 21/01/2008, Colin Wetherbee <cww@xxxxxxxxxxxxxxxx> wrote: >> Pavel Stehule wrote: >>> when database uses different encoding, than is specified in cluster's >>> initialization, then lower, upper doesn't work. >> >> Oooh. That's... confusing. > yes, postgresql support different encodings, but this configuration is > useless with non C locale. FWIW, I think we've got 8.3 fixed so that it will reject combinations of locale and encoding that don't work. It's a bit tricky because of the fact that locale processing isn't too well standardized :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster