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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
