Thread: Problm Drop Table :: 748580

Problm Drop Table :: 748580

From
"Eko Pranoto"
Date:
Dear all,
I want drop table "hasil_lab" and comes message...

ERROR:  cache lookup of relation 748580 failed

I'm using...
Mandrake 9.1
PostgreSQL 7.3.2 pack with linux distribution
psql as postgres

Why it can be happen ?
I query the table with command "select * from hasil_lab"
is find.
I have vacuumdb that database.

regards,
Eko Pranoto
===========================================================================================
Gunakan layanan download ringtone dan wallpaper dari Fun Dering dari PlasaCom untuk menambah keceriaan di handphone
Anda...http://fun-dering.plasa.com 
===========================================================================================

Re: Problm Drop Table :: 748580

From
Tom Lane
Date:
"Eko Pranoto" <koprapostgres@telkom.net> writes:
> I want drop table "hasil_lab" and comes message...
> ERROR:  cache lookup of relation 748580 failed

Hmm ... is that the same relation?  What do you get from
    select * from pg_class where oid = 748580;
If nothing, how about
    select oid from pg_class where relname = 'hasil_lab';

            regards, tom lane

Re2: Problm Drop Table :: 748580

From
"kopra"
Date:
>
> Hmm ... is that the same relation?  What do you get from
> select * from pg_class where oid = 748580;

I not find that number

> If nothing, how about
> select oid from pg_class where relname = 'hasil_lab';
>

I find different number...
any clue ?

Regards
Eko Pranoto

Re: Re2: Problm Drop Table :: 748580

From
Tom Lane
Date:
"kopra" <koprapostgres@telkom.net> writes:
>> If nothing, how about
>> select oid from pg_class where relname = 'hasil_lab';

> I find different number...
> any clue ?

If you want to be walked through this, you're going to have to offer
more than minimal amounts of information --- like, for example, the
number you did find.

At this point I'd like to see the rows in pg_depend that have either
objid or refobjid equal to 748580, as well as those matching hasil_lab's
OID.  I think you must have some kind of problem with a dangling
dependency, but we're going to have to work through it to see what
went wrong.

            regards, tom lane