From: | "psql psql" <psql(at)unrulymedia(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Stemming not working with tsearch2() function |
Date: | 2007-04-30 08:50:56 |
Message-ID: | 8ab0788c0704300150va8bd75ds5d18c506291a08b0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Anyone know why to_tsvector('sausages') might return "sausages" while
to_tsvector('default','sausages') correctly returns "sausag"?
This is causing me a fairly major headache. I am guessing that the
tsearch2() function used in my trigger is not specifying "default" when
creating the tsvector since the words be put into the vector are not
correctly stemmed (if that is the correct term).
I figure this may be something to do with locale settings, other info:
postgresql version 8.2.4 (upgraded from 8.2.0 by rpm on Fedora Core 6 and
prior to that from a 7.x version although i reinstalled tsearch2)
SELECT * from pg_ts_cfg;
ts_name | prs_name | locale
-----------------+----------+--------------
default_russian | default | ru_RU.KOI8-R
utf8_russian | default | ru_RU.UTF-8
simple | default | en_US.UTF-8
default | default | en_US.UTF-8
lc_collate | en_US.UTF-8
lc_ctype | en_US.UTF-8
lc_messages | en_US.UTF-8
lc_monetary | en_US.UTF-8
lc_numeric | en_US.UTF-8
lc_time | en_US.UTF-8
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2007-04-30 10:55:56 | Re: Stemming not working with tsearch2() function |
Previous Message | FAST PostgreSQL | 2007-04-30 05:10:50 | Re: SOS, help me please, one problem towards the postgresql developement on windows |