Re: Eeek! Major problem after reload with tsearch2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karl Denninger <karl(at)denninger(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Eeek! Major problem after reload with tsearch2
Date: 2005-02-03 21:06:47
Message-ID: 5035.1107464807@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karl Denninger <karl(at)denninger(dot)net> writes:
> Ok, I found out what was going on with the tsearch2 module and reloading
> after an upgrade to 8.0.1 from 7.4.1

> ERROR: cache lookup failed for function 36476

I think that tsearch2's control tables contain function OIDs, which
means that you can't just dump them out of one installation and load
into a new one ... you have to regenerate the table contents by running
the tsearch2.sql script.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rory Campbell-Lange 2005-02-03 21:13:57 Re: Select from function for part of column results
Previous Message Karl Denninger 2005-02-03 21:03:03 Re: Eeek! Major problem after reload with tsearch2