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.krumins@komin.lv
mob tel: 9719772
tel:7505574
fax:7282590