Rick,
did you load tsearch2 itself into your database ?
Oleg
On Thu, 7 Dec 2006, Rick Schumeyer wrote:
> I am trying to copy a database that uses tsearch2 from pg8.1 to pg8.2.
>
> All I did to install tsearch2 was cd to the contrib/tsearch2 directory, then
> make, make install.
>
> I then dumped the database from pg8.1 and used psql -f filename db to load in
> into pg8.2.
>
> Attempting a query gives an error:
>
> lib2=# select * from item where idxTitle @@ to_tsquery('default', 'money');
> ERROR: No dictionary with name 'en_stem'
>
> Is there a document that describes the necessary steps to convert to the
> upgraded tsearch2?
>
>
>
> ---------------------------(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