RES: RES: Issue on Varchar Ordering - Mailing list pgsql-admin

From Erika Terahata Torres Prada e Silva - MPS
Subject RES: RES: Issue on Varchar Ordering
Date
Msg-id 5519B95F9CA8B94DA8DE3F0A33375672017D5766@wtdfl055.prevnet
Whole thread Raw
List pgsql-admin

Thanks Alvaro,

Mine is:

| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err:
uppercase=bad)
||/ Name           Version        Description
+++-==============-==============-==========================================
==
ii  libc6          2.3.2.ds1-22sa GNU C Library: Shared libraries and
Timezone
No packages found matching Desired=Unknown/Install/Remove/Purge/Hold.


-----Mensagem original-----
De: Alvaro Herrera [mailto:alvherre@commandprompt.com]
Enviada em: sexta-feira, 18 de agosto de 2006 10:54
Para: Erika Terahata Torres Prada e Silva - MPS
Cc: pgsql-admin@postgresql.org
Assunto: Re: RES: [ADMIN] Issue on Varchar Ordering

Erika Terahata Torres Prada e Silva - MPS wrote:
> OS Debian 3.1
>
> Show lc_collate:
>
> "pt_BR.ISO-8859-1"
>
> It returns:
>     GABRIELA HELEDA DE SOUZA
>       GABRIELA JACOBY NOS
>       GABRIEL ALCIDES KLIM PERONDI
>       GABRIELA LETICIA BATISTA NUNES
>       GABRIEL ALEXANDRE DA SILVA MANICA
>
> The correct would be:
>
>     GABRIEL ALCIDES KLIM PERONDI
>     GABRIEL ALEXANDRE DA SILVA MANICA
>     GABRIELA HELEDA DE SOUZA
>     GABRIELA JACOBY NOS
>     GABRIELA LETICIA BATISTA NUNES
>
> As I told you, with OS Windows, it works correctly...

Strange.  I'm using Debian unstable here and it works fine, i.e., just
as you expect.  This sounds like a glibc bug to me; one corrected after
3.1.  (Is that Sarge?  I don't know the version numbers.)

What version of the libc6 package do you have installed?  I have 2.3.6-18
here.

$ LC_MESSAGES=C dpkg -l libc6
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-files/Unpacked/Failed-config/Half-installed
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err:
uppercase=bad)
||/ Name                    Version                 Description
+++-=======================-=======================-========================
======================================
ii  libc6                   2.3.6-18                GNU C Library: Shared
libraries


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-admin by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: front-end to Postgres
Next
From: Bruno Wolff III
Date:
Subject: Re: vacuumdb exclude tables option?