Home > Archive > PostgreSQL Bugs > February 2006 > Re: BUG #2286: Wrong index creation with cs_CZ locales and









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: BUG #2286: Wrong index creation with cs_CZ locales and
David Sauer

2006-02-28, 8:33 pm

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) or 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:
>
> 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.
>
> regards, tom lane



--
David Šauer <david.sauer@videoplaneta.cz>
www.videoplaneta.cz
člen internetového nákupního centra www.123shop.cz
navštivte naše obchody: www.123mp3.cz www.fotoplaneta.cz a další ...

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com