From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ray Ontko <rayo@ontko.com>
Cc: nickf@ontko.com, pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration
Date: Fri, 10 May 2002 12:48:26 -0400
Message-ID: <29201.1021049306@sss.pgh.pa.us> (raw)
In-Reply-To: <200205101635.LAA10840@shire.ontko.com>
References: <200205101635.LAA10840@shire.ontko.com>
Ray Ontko <rayo@ontko.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, rayo@ontko.com
Subject: Re: A couple of errors encountered in 7.1.3=>7.2.1-2 data migration
In-Reply-To: <29201.1021049306@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox