tsearch2 errors after db move

From: Matthew Terenzio <matt(at)jobsforge(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: tsearch2 errors after db move
Date: 2005-07-04 02:50:21
Message-ID: 98122978e82343106ee91ad141cdc591@jobsforge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I recently moved a database to a new machine:
PostgreSQL 7.4.7 on i386-portbld-freebsd5.3, compiled by GCC cc (GCC)
3.4.2 [FreeBSD] 20040728

any queries related to tsearch2 give me this error:

ERROR: cache lookup failed for function 17188

I am running the same versions of Postgres, Freebsd, etc

I guess my next move might be to run untsearch2.sql on both machines,
do a new dump , and try to rebuild tsearch2 from scratch on on both
machines

Unless someone knows better?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message laser 2005-07-04 04:10:59 out of memory problem in CVS
Previous Message Dawid Kuroczko 2005-07-04 00:07:47 Re: Hot to restrict access to subset of data