Re: Can't dump database - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Can't dump database
Date
Msg-id Pine.BSF.4.10.10009210951440.62098-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Can't dump database  (Giovanni Ianelli <janez@ipruniv.cce.unipr.it>)
List pgsql-admin
I'm not sure this will have anything to do with it, but
what do you get when you do a
select * from pg_attribute where attrelid=1255;

Without looking into code, I'm guessing that the 1255 might be the
relation oid and -2 the attribute number (which would be oid?).

Stephan Szabo
sszabo@bigpanda.com

On Thu, 21 Sep 2000, Giovanni Ianelli wrote:

> John St�ck wrote:
>
> > I can't do database dumps! I just get this error message:
> > getFuncs(): SELECT failed.  Explanation from backend: 'ERROR:
> > getattproperties: no attribute tuple 1255 -2
> > '.
> >
> > This is regardless of which database I try to dump (including newly created
> > totally empty ones), with which user (my "normal" user, any other user or
> > postgres), or whether or not the database has any functions in it.
> > If I run pg_dumpall, it starts dumping some stuff from template1, but when
> > it connects to the first "regular" database, it bails ut with the same
> > error. Also, just running "pg_dump template1" generates that same error too.
> >
> > I'm running PostgreSQL 7.0.2 on LinuxPPC-2000. I've also tried the same
> > thing on LinuxPPC-1999. Same result.
> >
> > /John
>
> > I found the same problem. I'm running postgresql 7.0.2
>
> under LinuxPPC 1999 but I copy a db to a postgresql 7.0.1
> under Suse 6.4 i586 and now i have the same problem on
> this pc ,too.


pgsql-admin by date:

Previous
From: Giovanni Ianelli
Date:
Subject: Re: Can't dump database
Next
From: Loïc TREGOUËT
Date:
Subject: problem with table system