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
> usatest=# SELECT lexize 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
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 Wieland||Date: 2006-01-24 09:27:58|
|Subject: Re: [HACKERS] CIDR/INET improvements|
|Previous:||From: Aftab Alam||Date: 2006-01-24 09:20:18|
|Subject: Re: Offer for PG Developers/Hackers|