Re: help with corrupted database

strk wrote:
> On Wed, Mar 23, 2005 at 01:48:11PM +0000, Richard Huxton wrote:
> 
>>strk wrote:
>>
>>>Hello.
>>>A memory fault in a trigger left my database
>>>in a corrupted state:
>>>
>>
>>>    - I can't create temporary tables anymore
>>>      (restart/vacuum full don't help)
>>>      ERROR:  cache lookup failed for relation 1250714
>>
>>*What* is giving this error? Something seems to be holding onto a 
>>reference to (at a guess) your temporary table. Can you identify what?
> 
> 
> Whatever is called from create temp table ..
> 
> strk=# create temp table test1(a int);
> ERROR:  cache lookup failed for relation 1250714
> strk=# create temp table test2(a int);
> ERROR:  cache lookup failed for relation 1250714

Have you disconnected/reconnected since deleting the temp table?

--  Richard Huxton  Archonet Ltd