From: | "Michael Harris (BR/EPA)" <michael(dot)harris(at)ericsson(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: cache lookup failed for type 0 |
Date: | 2007-05-25 05:45:45 |
Message-ID: | E5F4C5A18CAB7A4DA23080DE9CE8158603E67875@eaubrmw001.eapac.ericsson.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Am not sure if this is something we've done wrong or maybe a bug.
Whenever any kind of query is done on the table below, this is the
result:
ispdb_vxe=> select * from pm.carrier_on_13642;
ERROR: cache lookup failed for type 0
I first noticed it when I noticed that the regular backups were failing
- pg_dump gives the same output and stops.
I have tried
1. postgresql restart
2. vacuum full on the table
3. reindex of the table
I am using Postgres 8.2.3 running on Centos Linux 4.4.
Is there anything I can do to recover this table?
Is there any danger in dropping the table if it cannot be recreated?
Should this be reported as a bug? (although I have no clue as to how it
got into this state).
Regards,
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Harris (BR/EPA) | 2007-05-25 06:08:46 | ERROR: cache lookup failed for type 0 |
Previous Message | Steve Atkins | 2007-05-25 04:25:23 | Re: index vs. seq scan choice? |