Postgres Pro
Downloads
Home   >   mailing lists

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 11413.1105822004@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
List pgsql-hackers
Tree view 
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> Hrmmm ... how about if I pg_dump --oids pg_class, make the modes and then 
> reload it as opg_class, shut down the database server and move opg_class 
> over pg_class, after making the required modifications to opg_class?

Good idea.  Give it a shot.  Don't forget you'll need to REINDEX pg_class.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: sparse (static analyzer) report
Next
From: "Marc G. Fournier"
Date:
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid