From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Ray Ontko <rayo(at)ontko(dot)com> |
Cc: | nickf(at)ontko(dot)com, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration |
Date: | 2002-05-10 16:48:26 |
Message-ID: | 29201.1021049306@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Ray Ontko <rayo(at)ontko(dot)com> writes:
> develop=# select count(*) from temp_event ;
> ERROR: cannot find attribute 1 of relation temp_event
I'm beginning to think there is something seriously messed up about your
installation. The simplest theory is that the indexes on pg_attribute
are corrupted. You could try a query that won't use the indexes, eg
select (select relname from pg_class where oid = attrelid)
from pg_attribute where attnum = 1 order by 1;
and look through the output to see if temp_event and the other broken
table are mentioned. If so, then the rows are there but the index is
wrong. You should be able to recover using REINDEX --- read the
reference page for it carefully before executing the recovery procedure!
If that doesn't work, re-initdb and re-importation of your dump would be
a good next step. Something must have dropped a bit somewhere...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-10 16:55:12 | Re: BufferLookup table corrupted |
Previous Message | Ray Ontko | 2002-05-10 16:35:42 | Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration |