The db was initialized for 4 months. And in rest I did nothing regarding the initialization.
I solved the problem by delete/reinit the database. I really don't know what caused this. A day before I noticed the problem I made a "live update" for suse 8.2. I will look also the log files, maybe I find there something. If I found something "strange" I post it. Thankx to all. ----- Original Message ----- From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "Andrei Bintintan" <[EMAIL PROTECTED]> Cc: "[ADMIN]" <[EMAIL PROTECTED]> Sent: Tuesday, November 25, 2003 7:53 PM Subject: Re: [ADMIN] Sensitive sort problem? > On Tue, 25 Nov 2003, Andrei Bintintan wrote: > > > I give an example: > > > > These are the datas from the table names: > > > > id n1 n2 > > 1 AaAa AaAa > > 2 X X > > 3 A A > > 4 a a > > 5 ab ab > > 6 _Y _Y > > 8 ..a ..a > > 9 .x .x > > 7 ...a ...a > > > > If I run: select * from names order by n1: the result is: > > > > id n1 n2 > > 4 a a > > 8 ..a ..a > > 7 ...a ...a > > 3 A A > > 1 AaAa AaAa > > 5 ab ab > > 9 .x .x > > 2 X X > > 6 _Y _Y > > > > Which I don't think that is right. I don't know what happened. But I > > find that the ASCII char order is not respected here. > > As Tom said, you've probably run initdb in a locale other than "C". > For example, I believe the above is correct for en_US. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings