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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-01-15 21:48:56 | Re: WAL logging of heap_mark4update |
Previous Message | Alvaro Herrera | 2005-01-15 21:32:29 | WAL logging of heap_mark4update |