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: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid
Date: 2005-01-15 21:34:18
Message-ID: 20050115172940.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:
>> 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 do
> 	update pg_attribute set attrelid = 5773277 where attrelid = 8709051;
> and repeat for each toast table you need to fix.

Wow ... as painful as that whole thing is/was ... it looks like I might 
actually have covered all the system tables that needed to be modified ... 
'select * from email'; actually seems to show correct data now, without 
errors ...

Only 9 more to repeat this with ...

Thanks ...


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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-01-15 21:48:56
Subject: Re: WAL logging of heap_mark4update
Previous:From: Alvaro HerreraDate: 2005-01-15 21:32:29
Subject: WAL logging of heap_mark4update

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