Temp table problem.

[Juris Krumins]

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:ju***********@komin.lv
mob tel: [phone]
tel:[phone]
fax:[phone]

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org