help with corrupted database

From: strk <strk(at)keybit(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: help with corrupted database
Date: 2005-03-23 13:35:27
Message-ID: 20050323133527.GE7498@freek.keybit.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2005-03-23 13:48:11 Re: help with corrupted database
Previous Message Simon Riggs 2005-03-23 13:28:26 Re: odd problem !