Re: BUG #2286: Wrong index creation with cs_CZ locales and - Mailing list pgsql-bugs

From David Sauer
Subject Re: BUG #2286: Wrong index creation with cs_CZ locales and
Date
Msg-id 20060228104819.cc0118d9.profa@profa.cz
Whole thread Raw
In response to Re: BUG #2286: Wrong index creation with cs_CZ locales and HYPHEN  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
No, the database was initialized new.

initdb -D /var/lib/pg-8.1.3 -E latin2

I have isolated problem to new locale definition file - glibc 2.3.6 with cs=
_CZ definition file from 2.3.2 works ok and raises if data contain '-'.
I'am still not sure if problem is in postgres (bad work with locale data) o=
r in glibc locale data itself, older postgres than 8.1.2 still not tried.

Thanks,

On Mon, 27 Feb 2006 12:24:19 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "David Sauer" <profa@profa.cz> writes:
> > PostgreSQL version: 8.1.2, 8.1.3
> > Operating system:   Linux (libc6), debian
> > Description:        Wrong index creation with cs_CZ locales and HYPHEN
>=20
> You've probably gotten bit by the 8.1.2 changes in locale-dependent
> sorting.  Try REINDEXing the affected indexes, as per the 8.1.2 release
> notes.
>=20
>             regards, tom lane


--=20
David =A9auer <david.sauer@videoplaneta.cz>
www.videoplaneta.cz
=E8len internetov=E9ho n=E1kupn=EDho centra www.123shop.cz
nav=B9tivte na=B9e obchody: www.123mp3.cz www.fotoplaneta.cz a dal=B9=ED ...

pgsql-bugs by date:

Previous
From: "Jonathan Albert C. Vallar"
Date:
Subject: BUG #2288: bad value for type timestamp using JDBC Type2 Driver version 8.1-405
Next
From: "Oleg Mamontov"
Date:
Subject: BUG #2290: Incorrect sequence increment after backup/restore