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

Tsearch2 dump/reload problem

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Tsearch2 dump/reload problem
Date: 2004-07-28 16:42:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
PostgreSQL 7.4.2 - 

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

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)

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

...I'm desperate...


Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages! 


pgsql-general by date

Next:From: Daniel VeriteDate: 2004-07-28 16:45:50
Subject: Re: Sql injection attacks
Previous:From: Tom LaneDate: 2004-07-28 16:37:26
Subject: Re: tablename type?

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