From: marvin.deoliveira <marvin.deoliveira@gmail.com>
To: pgsql-admin@postgresql.org
Subject: corrupted rows in pg_attribute deleted
Date: Tue, 6 Sep 2011 12:57:46 -0700 (PDT)
Message-ID: <1315339066571-4775814.post@n5.nabble.com> (raw)
--------------------------------------
| Postgres Version 9.0.2 |
--------------------------------------
After a Kernel Panic in Debian 5, we found corrupted rows in pg_attribute
about 2 tables.
I deleted the rows and updated the pg_class.relnatts with the result of:
SELECT count(*) FROM pg_attribute WHERE attnum > 0 AND attrelid = 167017 --
Returned 22 rows.
where 167017 is the one of the tables OID.
Now I got the following messages:
1 - When PgAdmin III list the table structure for the first time:
ERROR: invalid attribute number 23 for fase_laudo_apac
LINE 1: Select count(*) as rows from only fase_laudo_apac
2- When I tried to drop the fase_laudo_apac table:
An error has occourred:
ERROR: cache lookup failed for attribute 3 of relation 167045
Any help will be really appreciated
-----
Marcos Oliveira
--
View this message in context: http://postgresql.1045698.n5.nabble.com/corrupted-rows-in-pg-attribute-deleted-tp4775814p4775814.htm...
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
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: marvin.deoliveira@gmail.com
Subject: Re: corrupted rows in pg_attribute deleted
In-Reply-To: <1315339066571-4775814.post@n5.nabble.com>
* 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