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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-01-15 21:20:13 | Re: FATAL: catalog is missing 1 attribute(s) for relid 16396 |
Previous Message | Marc G. Fournier | 2005-01-15 21:14:12 | Re: FATAL: catalog is missing 1 attribute(s) for relid |