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; ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
