Re: [GENERAL] Cache lookup failure for pg_restore?

2004-05-09 Thread Denis Braekhus
-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 a

Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

2004-05-09 Thread Denis Braekhus
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: |>Indicating that they should produce the same results, but that they work |>differently. I am not sure what that implies, but maybe someone else knows ? | The only difference the docs are talking about is what kind of lock is | held whi

Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

2004-05-08 Thread Denis Braekhus
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lonni Friedman wrote: | Thanks for your reply. I thought (perhaps erroneously) that there | wasn't any real difference between dropping an index then recreating | it, and just reindexing an index? I am definitely not sure, and I agree it sounds logica