help with corrupted database - Mailing list pgsql-hackers

From strk
Subject help with corrupted database
Date
Msg-id 20050323133527.GE7498@freek.keybit.net
Whole thread Raw
Responses Re: help with corrupted database  (Richard Huxton <dev@archonet.com>)
List pgsql-hackers
Hello.
A memory fault in a trigger left my database
in a corrupted state:
- A temporary table listed in pg_class  was not accessible with a select
- I could not DROP it
- I deleted the record from pg_class
- I can't create temporary tables anymore  (restart/vacuum full don't help)  ERROR:  cache lookup failed for relation
1250714

Any hint?

--strk;


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: odd problem !
Next
From: Richard Huxton
Date:
Subject: Re: help with corrupted database