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 11031.1105819111@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:
> Is there something in the 'table file' itself that is holding that relid? 

Oh, drat, you're right --- TOAST pointer datums contain the OID of
the toast file they are pointing to.  So any value wide enough to be
pushed out-of-line is going to have a problem.

Ugh.  Not sure there is any good way out of this one.  Adjusting the
pointer datums in-place doesn't seem very feasible.
        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: "Marc G. Fournier"
Date:
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid