"Chris Gamache" <[EMAIL PROTECTED]> wrote: > When I reload and attempt to access the database I find this > in the logs: > > ERROR: cache lookup failed for function 75769893
You should be OK as long as you have the dump file. If you haven't modifed any of the tsearch2 pg_ts_* tables, try and load tsearch2.sql first before loading the dump file. You will get a lot of errors when you load the dump file. It will try to create object that tsearch2.sql already created. Things should work if you haven't modified any of the tsearch2 tables. Below is some sample code. Change the names of the databases and the path to the *.sql files. createdb ts_db_b; psql ts_db_b < tsearch2.sql; psql ts_db_b < ts_db_a.sql; So what if you did modify the pg_ts_* tables? Load the dump file into a new database. Read about the regprocedure patch at: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html Install the file regprocedure_7.4.patch.gz, then load the following into your database. http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_update.sql George Essig ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
