Re: FATAL: catalog is missing 1 attribute(s) for relid - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: FATAL: catalog is missing 1 attribute(s) for relid
Date
Msg-id 20050115172940.H16498@ganymede.hub.org
Whole thread Raw
In response to Re: FATAL: catalog is missing 1 attribute(s) for relid 16396  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, 15 Jan 2005, Tom Lane wrote:

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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: WAL logging of heap_mark4update
Next
From: Tom Lane
Date:
Subject: Re: WAL logging of heap_mark4update