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

From Tom Lane
Subject Re: FATAL: catalog is missing 1 attribute(s) for relid 16396
Date
Msg-id 11807.1105824013@sss.pgh.pa.us
Whole thread Raw
In response to Re: FATAL: catalog is missing 1 attribute(s) for relid  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: FATAL: catalog is missing 1 attribute(s) for relid  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-hackers
"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 doupdate pg_attribute set attrelid = 5773277 where attrelid = 8709051;
and repeat for each toast table you need to fix.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid
Next
From: Alvaro Herrera
Date:
Subject: WAL logging of heap_mark4update