TSearch2 Problems

On Mon, 19 Mar 2007, Howard Cole wrote:

Hi,

I am having some problems with TSearch2 queries since upgrading from 8.0 to
8.2.

This is the query:

select count(*) from card, to_tsquery('default','test') as q where (q @@
card.fts);

This works fine on 8.0 but gives the following error in 8.2:

ERROR: No dictionary with name 'en_stem'

show us output of
select * from pg_ts_dict;

SQL state: XX000

Any help will be great. Thanks

Howard.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

show us output of select * from pg_ts_dict;

"simple";"dex_init(internal)";"";"dex_lexize(internal,internal,integer)";"Simple
example of dictionary."
"en_stem";"snb_en_init(internal)";"contrib/english.stop";"snb_lexize(internal,internal,integer)";"English
Stemmer. Snowball."
"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"
"ispell_template";"spell_init(internal)";"";"spell_lexize(internal,internal,integer)";"ISpell
interface. Must have .dict and .aff files"
"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"

Oleg,

My problem may have been solved by doing a "vacuum full analyse". I
shall check tomorrow and get back to you.

Thanks,

Howard.

Hi Oleg,

Everything seemed to work after the vacuum. Thanks for your prompt response.

Howard