Tsearch2 dump/reload problem - Mailing list pgsql-general

From Chris Gamache
Subject Tsearch2 dump/reload problem
Date
Msg-id 20040728164238.86952.qmail@web13805.mail.yahoo.com
Whole thread Raw
Responses Re: Tsearch2 dump/reload problem  (Ian Barwick <barwick@gmail.com>)
List pgsql-general
PostgreSQL 7.4.2 -

I'm having some serious problems dumping and reloading a database with utilizes
TSearch2.

I've followed the directions to-the-letter for dumping and reloading a DB that
uses TSearch2 ... When I reload and attempt to access the database I find this
in the logs:

ERROR:  cache lookup failed for function 75769893

Here's another kicker: I've dropped the original database that was (at least)
functional.

I didn't apply the regprocedure patch before I dumped. I have since applied the
regprocedure patch to my tsearch2.sql ...

...I'm desperate...

CG



__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: tablename type?
Next
From: "Daniel Verite"
Date:
Subject: Re: Sql injection attacks