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

On Sat, 15 Jan 2005, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.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@hub.org           Yahoo!: yscrappy              ICQ: 7615664