Skip site navigation (1) Skip section navigation (2)

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

From: David Sauer <profa(at)profa(dot)cz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2286: Wrong index creation with cs_CZ locales and
Date: 2006-02-28 09:48:19
Message-ID: 20060228104819.cc0118d9.profa@profa.cz (view raw or flat)
Thread:
Lists: 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) 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "David Sauer" <profa(at)profa(dot)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
> 
> 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(dot)sauer(at)videoplaneta(dot)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ší ...

In response to

pgsql-bugs by date

Next:From: Oleg MamontovDate: 2006-02-28 12:43:49
Subject: BUG #2290: Incorrect sequence increment after backup/restore
Previous:From: Abhilash KrishnanDate: 2006-02-28 09:24:35
Subject: BUG #2289: insert into tables not working

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group