From: | "Andrei Bintintan" <andy(at)ar-sd(dot)net> |
---|---|
To: | "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com> |
Cc: | "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Sensitive sort problem? |
Date: | 2003-11-26 07:15:38 |
Message-ID: | 003801c3b3ed$18d6feb0$0b00a8c0@andy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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" <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Andrei Bintintan" <klodoma(at)ar-sd(dot)net>
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrei Bintintan | 2003-11-26 07:18:13 | Re: Sensitive sort problem? |
Previous Message | Tom Lane | 2003-11-26 05:53:27 | Re: Size on Disk |