On Sat, 15 Jan 2005, Tom Lane wrote:
"Marc G. Fournier" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
