How to switch off Snowball stemmer for tsearch2?

From: "Dmitry Koterov" <dmitry(at)koterov(dot)ru>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: How to switch off Snowball stemmer for tsearch2?
Date: 2007-08-22 18:10:06
Message-ID: d7df81620708221110s6adedb07g9b5f93b8f8c3c38e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

We use ispell dictionaries for tsearch2 (ru_ispell_cp1251)..
Now Snowball stemmer is also configured.

How to properly switch OFF Snowball stemmer for Russian without turning off
ispell stemmer? (It is really needed, because "Ivanov" is not the same as
"Ivan".)
Is it enough and correct to simply delete the row from pg_ts_dict or not?

Here is the dump of pg_ts_dict table:

dict_name dict_init dict_initoption dict_lexize dict_comment
en_ispell spell_init(internal)
DictFile=/usr/lib/ispell/english.med,AffFile=/usr/lib/ispell/english.aff,StopFile=/usr/share/pgsql/contrib/english.stop
spell_lexize(internal,internal,integer)
en_stem snb_en_init(internal) contrib/english.stop
snb_lexize(internal,internal,integer) English Stemmer. Snowball.
ispell_template spell_init(internal)
spell_lexize(internal,internal,integer) ISpell interface. Must have .dict
and .aff files
ru_ispell_cp1251 spell_init(internal)
DictFile=/usr/lib/ispell/russian.med,AffFile=/usr/lib/ispell/russian.aff,StopFile=/usr/share/pgsql/contrib/russian.stop.cp1251
spell_lexize(internal,internal,integer)
ru_stem_cp1251 snb_ru_init_cp1251(internal)
contrib/russian.stop.cp1251 snb_lexize(internal,internal,integer)
Russian Stemmer. Snowball. WINDOWS (cp1251) Encoding
ru_stem_koi8 snb_ru_init_koi8(internal) contrib/russian.stop
snb_lexize(internal,internal,integer) Russian Stemmer. Snowball. KOI8
Encoding
ru_stem_utf8 snb_ru_init_utf8(internal) contrib/russian.stop.utf8
snb_lexize(internal,internal,integer) Russian Stemmer. Snowball. UTF8
Encoding
simple dex_init(internal) dex_lexize(internal,internal,integer)
Simple example of dictionary.
synonym syn_init(internal)
syn_lexize(internal,internal,integer) Example of synonym dictionary
thesaurus_template thesaurus_init(internal)
thesaurus_lexize(internal,internal,integer,internal) Thesaurus template,
must be pointed Dictionary and DictFile

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2007-08-22 18:46:59 Re: How to switch off Snowball stemmer for tsearch2?
Previous Message Dmitry Koterov 2007-08-22 17:50:56 Re: Postgres, fsync and RAID controller with 100M of internal cache & dedicated battery