Re: Sensitive sort problem?

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@megazone.bigpanda.com>
To: "Andrei Bintintan" <klodoma@ar-sd.net>
Cc: "[ADMIN]" <pgsql-admin@postgresql.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.