Problm Drop Table :: 748580

[Eko Pranoto]

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
===========================================================================================

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

Post by Eko Pranoto
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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[kopra]

Post by Tom Lane
Hmm ... is that the same relation? What do you get from
select * from pg_class where oid = 748580;

I not find that number

Post by Tom Lane
If nothing, how about
select oid from pg_class where relname = 'hasil_lab';

I find different number...
any clue ?

Regards
Eko Pranoto

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Tom Lane]

Post by kopra

Post by Tom Lane
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)