TSearch2 Problems

From: Howard Cole <howardnews(at)selestial(dot)com>
To: 'PgSql General' <pgsql-general(at)postgresql(dot)org>
Subject: TSearch2 Problems
Date: 2007-03-19 18:41:25
Message-ID: 45FED955.7010507@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glen W. Mabey 2007-03-19 18:49:17 Re: deleting a foreign key that has no references
Previous Message Tom Lane 2007-03-19 18:31:03 Re: Possible planner bug?