Skip site navigation (1) Skip section navigation (2)

Re: FATAL: catalog is missing 1 attribute(s) for relid

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid
Date: 2005-01-15 21:15:24
Message-ID: 20050115171430.U16498@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, 15 Jan 2005, Tom Lane wrote:

> "Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
>> belay that one ... my error, wasn't doin ghte reindex right ... fixed the
>> pg_class issue, but still have one with the email table itself in
>> multi-user:
>
>> restore=# select * from email;
>> ERROR:  catalog is missing 3 attribute(s) for relid 5773277
>
>> but, have an idea I'm going to try one that one ...
>
> Doh.  You'd also need to update pg_attribute.attrelid ... and probably
> pg_index entries that reference the toast tables ...

'k, that's what I was starting to think ... will continue down that route 
...

> I think that you should just be thinking in terms of getting to the
> point where you can pg_dump successfully, and then load the data into a
> new database.  You'll never be able to get all the catalogs perfectly
> right.

that is all that I'm trying to get to ...


----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-01-15 21:20:13
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid 16396
Previous:From: Marc G. FournierDate: 2005-01-15 21:14:12
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group