Re: help with corrupted database

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

PostgreSQL 8.0.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (Debian)

--strk;