Обсуждение: Cache lookup failed error in tsearch2?
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? Chris
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