Cache lookup failed error in tsearch2?

On Tuesday 24 January 2006 02:03, Christopher Kings-Lynne wrote:

What would be the cause of this error after upgrading from pgsql 7.4 to
8.1?

usatest=# SELECT lexize[1] FROM lexize('en_stem', 'bacon');
ERROR: cache lookup failed for function 861011

Does tsearch2 need to somehow be tweaked after the upgrade?

How did you dump and reload?

In 7.4 OIDs were used as column types in tsearch2. They were changed to
regprocedure types.

There is a patch to apply to tsearch2 for 7.4 :
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_7.4.patch.gz

You can also use the sql script I wrote to make mods to your tsearch2 tables
real time so a dump / reload will work :
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_update.sql

Andy

On Tue, 24 Jan 2006, Christopher Kings-Lynne wrote:

What would be the cause of this error after upgrading from pgsql 7.4 to 8.1?

usatest=# SELECT lexize[1] FROM lexize('en_stem', 'bacon');
ERROR: cache lookup failed for function 861011

Does tsearch2 need to somehow be tweaked after the upgrade?

you miss regprocedure_7.4.patch.gz, available from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

Chris

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