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

On Sat, 15 Jan 2005, Tom Lane wrote:

> "Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
>> which there are more then 3 attributes ... but, of course, there is
>> nothing for the one I just manually added to pg_class ... should this just
>> be duplicated for 5773277?
>
> No, just do
> update pg_attribute set attrelid = 5773277 where attrelid = 8709051;
> and repeat for each toast table you need to fix.

Wow ... as painful as that whole thing is/was ... it looks like I might
actually have covered all the system tables that needed to be modified ...
'select * from email'; actually seems to show correct data now, without
errors ...

Only 9 more to repeat this with ...

Thanks ...

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