Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group