| 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: | Whole Thread | Raw Message | 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/
| 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 |