Temp table problem. - Mailing list pgsql-general

From Juris Krumins
Subject Temp table problem.
Date
Msg-id 20040427163933.K61393@juriskr_workstation
Whole thread Raw
List 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.krumins@komin.lv
mob tel: 9719772
tel:7505574
fax:7282590

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: shadowing (like IB/Firebird)
Next
From: Timothy Perrigo
Date:
Subject: Re: questions on rules