Обсуждение: 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/