Tsearch + polish ispell + polish locale

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.

Responses

Browse pgsql-hackers by date

  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