Thread: TSearch2 Problems

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'
    SQL state: XX000

Any help will be great. Thanks

Howard.

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