-----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
