Skip site navigation (1) Skip section navigation (2)

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

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid
Date: 2005-01-15 21:00:05
Message-ID: 20050115165748.H16498@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, 15 Jan 2005, Tom Lane wrote:

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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-01-15 21:02:22
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid 16396
Previous:From: Tom LaneDate: 2005-01-15 20:46:44
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid 16396

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group