Thread: pg_dump on view
Hi One of my tables: zadania_wykonane | {"=","mtluser=arwR","mtldbbackup=r"} as a user mtldbbackup i do pg_dump and the last log info is: dumpRules(): SELECT failed for table zadania_wykonane. Explanation from backend: 'ERROR: cache lookup of attribute 0 in relation 54498 failed '. what does it mean? How to get rid of it, any hints? maz Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/
At 12:12 3/10/00 +0200, Marcin Mazurek wrote: >Hi >One of my tables: > zadania_wykonane | {"=","mtluser=arwR","mtldbbackup=r"} > >as a user mtldbbackup i do pg_dump and the last log info is: >dumpRules(): SELECT failed for table zadania_wykonane. Explanation from >backend: 'ERROR: cache lookup of attribute 0 in relation 54498 failed >'. > >what does it mean? How to get rid of it, any hints? I'd guess this means that the underlying table has been deleted... ---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 0500 83 82 82 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp5.ai.mit.edu:11371 |/
> >as a user mtldbbackup i do pg_dump and the last log info is: > >dumpRules(): SELECT failed for table zadania_wykonane. Explanation from > >backend: 'ERROR: cache lookup of attribute 0 in relation 54498 failed > >'. > >what does it mean? How to get rid of it, any hints? > I'd guess this means that the underlying table has been deleted... it's a view and working one but what i noticed: mtldb=# \d zadania_wykonane ERROR: cache lookup of attribute 0 in relation 59299 failed mtldb=# Marcin Mazurek -- Kierownik Działu Systemowego MULTINET SA o/Poznan http://www.multinet.pl/