It was my understanding that running pgdump creates a file that contains
all the necessary commands to use tsearch2. That approach has worked for
me to transfer my database from one pg8.1 server to another. I now see
that is does *not* work from pg8.1 to pg8.2.
At your suggestion I loaded tsearch2.sql before loading the pgdump
output. I get some errors in the second part, I believe because it
attempts to load tsearch2 stuff from the pg8.1 database that conflicts
with the pg8.2 stuff from tsearch2.sql. But, the queries seem to work.
So perhaps the answer is, load tsearch2.sql, then load the result of
running pgdump on the 8.1 database, and ignore the errors?
Oleg Bartunov wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
