Temp table problem.

From: Juris Krumins <juriskr(at)komin(dot)lv>
To: pgsql-general(at)postgresql(dot)org
Subject: Temp table problem.
Date: 2004-04-27 14:07:19
Message-ID: 20040427163933.K61393@juriskr_workstation
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


SELECT oid,relname FROM pg_class WHERE oid>=100000000;

gives me this output.
oid | relname . . .
-----------------------------------------
125538806 | tmp_table1 . . .
125538808 | pg_toast_125538806
125538810 | pg_toast_125538806_index . . .
125538811 | pg_toast_125538804
125538813 | pg_toast_125538804_index . . .
149064745 | pg_toast_149064743
149064747 | pg_toast_149064743_index . . .
165058651 | pg_toast_165058647
165058653 | pg_toast_165058647_index . . .

So we can see that the problem i had with temp table creating and cache
maybe lay in this output.
As we can see tmp_table1 have oid. But we don't have any name, which
reference to tables with oid's 149064743 and 165058647, which cause errors
i have in my serverlog file.

So the next question is what to do to make database look correct.
Suppose I can do someting like that:

DELETE FROM pg_class WHERE oid = 149064745;
DELETE FROM pg_class WHERE oid = 149064747;
DELETE FROM pg_class WHERE oid = 165058651;
DELETE FROM pg_class WHERE oid = 165058653;

DELETE FROM pg_index WHERE indexrelid = 149064747;
DELETE FROM pg_index WHERE indexrelid = 165058653;

would it be correct or any toher suggestions ?

Juris Krumins
SIA KOMIN
Sistemas Administrator
e-pasts:juris(dot)krumins(at)komin(dot)lv
mob tel: 9719772
tel:7505574
fax:7282590

Browse pgsql-general by date

  From Date Subject
Next Message Timothy Perrigo 2004-04-27 14:19:34 Re: questions on rules
Previous Message Bruce Momjian 2004-04-27 13:53:08 Re: shadowing (like IB/Firebird)