Skip site navigation (1) Skip section navigation (2)

Re: Cache lookup failed error in tsearch2?

From: "Andrew J(dot) Kopciuch" <akopciuch(at)bddf(dot)ca>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Cache lookup failed error in tsearch2?
Date: 2006-01-24 09:26:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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 :

You can also use the sql script I wrote to make mods to your tsearch2 tables 
real time so a dump / reload will work :


In response to

pgsql-hackers by date

Next:From: Joachim WielandDate: 2006-01-24 09:27:58
Subject: Re: [HACKERS] CIDR/INET improvements
Previous:From: Aftab AlamDate: 2006-01-24 09:20:18
Subject: Re: Offer for PG Developers/Hackers

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group