Recently, we discover how to avoid problem with OIDs backup/restore in tsearch2. Check http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ for a little patch (regprocedure_7.4.patch.gz). It won't work on existed tsearch2 installation, though, but will help in future. Oleg On Sun, 9 May 2004, Denis Braekhus wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Razvan Surdulescu wrote: > > | After I restore a Postgres database (using pg_restore), I get the > | following error message when I try to run a simple UPDATE query: > | > | ERROR: cache lookup failed for function 70529 > > Hi Razvan, > > Just to add to what Tom has already said, this is most certainly because > of your tsearch/gist usage. Check the Tsearch2 site [1] for a lot of > interesting documentation on Tsearch2. > For a quite nice howto on backups and restores of databases with > Tsearch2 see the Tsearch2 Intro document [2] > > There is actually now a patch [3] to tsearch (only for 7.4 though) which > is supposed to improve dumping and reloading of tsearch2 databases. > > [1] http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ > [2] > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html > [3] > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_7.4.patch.gz > > Best Regards > - -- > Denis > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.2-nr2 (Windows XP) > > iD8DBQFAniUSvsCA6eRGOOARAtJpAKCt4Wcrea3bIxu8fXw/5ZNFACdohwCfZPDf > UuCk1dXLx8SCS4/qMniC2z4= > =871m > -----END PGP SIGNATURE----- > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
