Обсуждение: Problm Drop Table :: 748580
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 ===========================================================================================
"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
> > 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
"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