Re: Tsearch + polish ispell + polish locale

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: arkadiusz(dot)staron(at)dreamlab(dot)pl
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tsearch + polish ispell + polish locale
Date: 2006-11-21 18:33:26
Message-ID: 45634676.7070004@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> I solved my problem by creating my own tolower() function and replace it over the tsearch2 code.
> On database with locale set to 'C' it works fine.
>
> As far As I debugged the problem I could observe that with locale = 'C' RS_compile() is fed only with strings that does not contain polish letters.
> With locale set to 'pl_PL.iso88592' strings passed to PS_compile contain polish letters.
> I do not know how, but in some strange, random cases function isalpha() stops return true value for polish letters, and that is when RS_compile() returns error.
Hmm, very strange. Which OS do you use?
Pls, show exact
# show lc_ctype;
# show lc_collate;
and tsearch2 configuration

>
> I will try to compile and run my database on the CVS version of postgres, and let you know the results.
ok

> Is it safe to use 8.2 version over 8.1.5 database files ?
No, it's impossible due to significant format of db's files change.

>
> BTW. When the official 8.2 release is expected ?

During 2006 :)

>
> Thanks for your time and engagement,
> Arek.
>
> PS. BTW I have found minor inconsistency in the regis.c code (CVS version)
> Return value type is not as it should .. see snippet below...
fixed
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matt Miller 2006-11-21 18:59:49 Re: [GENERAL] Allowing SYSDATE to Work
Previous Message Bruce Momjian 2006-11-21 18:30:36 Re: [HACKERS] Replication documentation addition