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

belay that one ... my error, wasn't doin ghte reindex right ... fixed the 
pg_class issue, but still have one with the email table itself in 
multi-user:

restore=# select * from email;
ERROR:  catalog is missing 3 attribute(s) for relid 5773277

but, have an idea I'm going to try one that one ...


On Sat, 15 Jan 2005, Marc G. Fournier wrote:

> On Sat, 15 Jan 2005, Tom Lane wrote:
>
>> "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.
>
> Doesn't seem to like that ...
>
> backend> reindex pg_class;
> ERROR:  syntax error at or near "pg_class" at character 9
>
> funny thing is, I can do a 'select * from pg_class' ... and I can do a 
> 'select * from email' now too ... but this is all in single user mode ... do 
> it from 'multi user', and I get:
>
> restore=# select * from email;
> ERROR:  relation "email" does not exist
>
> and:
>
> restore=# select * from pg_class;
> ERROR:  "category_id_remap_key" is an index
>
> seems *damn* close though ... thoughts?
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
>

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