From: | <arkadiusz(dot)staron(at)dreamlab(dot)pl> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Tsearch + polish ispell + polish locale |
Date: | 2006-11-20 10:19:34 |
Message-ID: | EA6A3F5C1E4BC14D91D93A344436440C010D300E@MXMBON01.grupa.onet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
I am experiencing strange problem using tsearch with polish locale on (initdb -locale pl_PL.iso88592) and polish ispell dictionary.
I have a pl/pgSQL function that creates tsvector for a given record (it basically gets texts from various tables and creates one tsvector)
The function returns semething like his:
RETURN setweight(to_tsvector(fname), ''A'')
|| setweight(to_tsvector(prov), ''C'')
[ ... 15 more lines like above ... ]
|| setweight(to_tsvector(firm_rec.fax), ''A'')
;
After several calls to this function I get an error:
psql> update some_table set fts_vect = record_to_tsvector(id) where id < 40;
ERROR: Error in regis: [^ż]ać at pos 3
Any idea show can I fix this ?
What is even more strange lower() function gets broken *after* this error occurs.
Before the error it correctly lowers polish letters, and after it does not lowercase them anymore.
After reconnecting to the database everything works fine (untill next error...)
Regards,
Arek.
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2006-11-20 13:24:48 | Re: psql: present working directory |
Previous Message | Simon Riggs | 2006-11-20 10:02:27 | Re: Transaction start in pg_stat_activity |