Re: furiously yours - Mailing list pgsql-bugs

From Lamar Owen
Subject Re: furiously yours
Date
Msg-id 01060811530000.00919@lowen.wgcr.org
Whole thread Raw
In response to furiously yours  ("Rony Khoury" <rkrk@hotmail.com>)
List pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 08 June 2001 05:20, Rony Khoury wrote:
[collation sequencing problem regarding space interpretation in ORDER BY]
> I would like to know if this was solved in the new version? and if not
> someone should defenetly do something about it.

This is not a PostgreSQL issue, but a locale issue that was introduced by Red
Hat implementing 'correct' locale collation. PostgreSQL has to rely on the
system's C library for the string comparison/collation routines -- and those
routines are greatly changed by the locale setting.

Red Hat does not view this behavior as buggy.

Trond, I didn't know whether you are subscribed to the BUGS list or not, so I
am  CC'ing you on this.  The two collations:

example
new version:
BOU MOUSLEH
BOUSTANI
BOU YAZBEK

old version
BOU MOUSLEH
BOU YAZBECK
BOUSTANI

This appears to me to be wrong, Trond.  Red Hat 7.1 out of the box
installation.

Rony, in the normal usage of these names, what would the correct collation be?
- --
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7IPTi5kGGI8vV9eERAnesAKC0RxdvdPs3EcFR9MAkapPs5drwbQCfVQuY
xrUfcfOFjEzLdCPsLbV59PM=
=bsSL
-----END PGP SIGNATURE-----

pgsql-bugs by date:

Previous
From: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Date:
Subject: Re: Apparent deadlock for simultaneous sequential scans
Next
From: Peter Eisentraut
Date:
Subject: Re: furiously yours