Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1guKfq-00061I-Q7 for pgsql-admin@arkaria.postgresql.org; Thu, 14 Feb 2019 17:19:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1guKfp-00024P-KI for pgsql-admin@arkaria.postgresql.org; Thu, 14 Feb 2019 17:19:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1guKfp-00024G-29 for pgsql-admin@lists.postgresql.org; Thu, 14 Feb 2019 17:19:45 +0000 Received: from sonic301-4.consmr.mail.bf2.yahoo.com ([74.6.129.43]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1guKfl-0000Za-Va for pgsql-admin@lists.postgresql.org; Thu, 14 Feb 2019 17:19:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1550164773; bh=qJtyWSx0lgkbKxAy6aaYTDc1+imUkdOiG8kZro7pUDo=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=JTi4J+xJZtDm2hPt1k8e7NwOPHIaA+ftLJNh6CV1AmOL73sDzWmxkJB7qgV9p4uYG0CSXOd/jOa07HoAmKmFStVLJLu8nVyFzy2ofS1eHxPxjfhttVCzHfsakmCs6vRcp2IKr/QGAS98bQjM7TMWMDi0ewSgF0A3xNaXs7IXsDdvTH/ejDXCSm0I5L85qDJM2WJzpCBjgEqiK81im6KOItwupR7jpeBSlWFrQL7SxS0y0OecKGLj8mVvD2M5HaZp/CvlVUhgjFV70r8p62aKHs8Qt31j+eQKMxJRNws57zBK9NUjCPbiR0VxuB7WbDeeb0ivJeT9vU/LjqpUOCLzhQ== X-YMail-OSG: E1we7_UVM1lCIxkAkTqB09F44ubSPijXPZ17SUvCElVenNS_PWlOiIyRBSlkXIC EDOvrjfUcFZ5wA.te79o0fYypilS9j2JBzKTss6SocnRO0JIBXgGcFl34pN3w5qhEoybOlpggGeZ hImpOW0XrBHLviULRDs5brYCkTbg8qdNAf92TfLxAIy2TlmfQ7XCSe3TPLnyEJK71qpz39moSdFu 3P5jpgKaGQvIrC5LF_H07_mCwdZvF00naF3Qn_LzjH70rASp.iUIG4AYtqaEjpJKY.I0hkOIq61T mnC8m_KZAuua6x5OvUoVnrtUyUy33_m20hz59f0L3KxYmXopFaG_MaZql3klN3mg18pCASbbaTMy dwUlTftSTiJGKHJWmzcz5VKYKTVFzlKjWXiAisbhAUu_mFKKnAADdBNrlddH.h6BAMuPDgdaXog1 gJudglFfKmkgOyQ1cDZDcH5EZVcwXazpF48mGCzXoJu1VDn0D3zIVPnRmpuP_1sZ2EmnYKR8s0q8 V2EzaGnLuJ2ZD1l8lyz2KapRmrlkJJXwFg_hlHQXIKPqZebpaVkAlDjUA8uXeXb5YHqfFLszl1ba dISwpXXbJUzCW5w8NBRijyCXRSU5131PeH5F2LnPNz.Anh6kG8.zX2BI4Bhd1i5Ye3WXOSK2YqA8 ut4EaaQH6u8Jb6zTQezs9xhSKgK0k2UWR8.5sPgdyjxu68jIgejWpnd9vsMSIvawz1HF0EfA1oD9 IfIUEjoZlwUWUlLyaTrkMNYRvtFvGmarAgl5cYenHtlFY.PFDZre3qOBZCVXjgpq4cqbb2uscXCF WqGhZuQ_azBQbsedTbf5HDqp2_a6S3fgh0U5TcTQEFT0jTCtoPX8gu_2YMmB6LHvqbrzUDvMB5ig GLV7qCfKp2qcXsHjf8RzZpH.ZpceD8LIoD.WPPESP5Ekjw7R5sqOAxqwrtZjYu7i6VOQ.xMcsdcV Vnwb36CONDDJo9TA.8WfMCybC89JKPvoItzjeuimF0RbHebflhAsg7u9YqiMk6tnHEAQ4xj.rrYV Gd3UPfeLEdSELtyA7lMhD0y0aYOTqBDkzzPgR3jcLKVSJsrrdI9Rpjmnh5tRB65KpGstmHZKC Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.bf2.yahoo.com with HTTP; Thu, 14 Feb 2019 17:19:33 +0000 Date: Thu, 14 Feb 2019 17:19:28 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "soumik.bhattacharjee@kpn.com" , "pgsql-admin@lists.postgresql.org" Message-ID: <1399539471.1040572.1550164768687@mail.yahoo.com> Subject: Re: Table Drop Error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1040571_1704931771.1550164768684" References: <1399539471.1040572.1550164768687.ref@mail.yahoo.com> X-Mailer: WebService/1.1.13041 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36 Content-Length: 16152 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1040571_1704931771.1550164768684 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I think you have something link to that table. I do have this issue before and I removed oid, objid and conrelid 1st befor= e drop the table do obtain oid of the table: select oid from pg_class c join pg_namespace non n.oid =3D c.relnamespace w= here c.relname =3D'' and n.nspname =3D ''; then delete oid, objid and conrelid: delete from pg_class where oid =3D ;delete from pg_depend where= objid =3D ;delete from pg_constraint where conrelid =3D ; finally drop your schema's table with cascade; =C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Thursday, February 14, 2019 11:52 AM, "soumik.bhattacharjee@kpn.com"= wrote: =20 #yiv7619060442 -- filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv7619060442 f= iltered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv7619060442 = p.yiv7619060442MsoNormal, #yiv7619060442 li.yiv7619060442MsoNormal, #yiv761= 9060442 div.yiv7619060442MsoNormal {margin:0in;margin-bottom:.0001pt;font-s= ize:12.0pt;font-family:New serif;}#yiv7619060442 a:link, #yiv7619060442 spa= n.yiv7619060442MsoHyperlink {color:blue;text-decoration:underline;}#yiv7619= 060442 a:visited, #yiv7619060442 span.yiv7619060442MsoHyperlinkFollowed {co= lor:purple;text-decoration:underline;}#yiv7619060442 p.yiv7619060442msonorm= al0, #yiv7619060442 li.yiv7619060442msonormal0, #yiv7619060442 div.yiv76190= 60442msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-fam= ily:New serif;}#yiv7619060442 span.yiv7619060442EmailStyle18 {font-family:s= ans-serif;color:#1F497D;}#yiv7619060442 span.yiv7619060442EmailStyle19 {fon= t-family:sans-serif;color:#1F497D;}#yiv7619060442 span.yiv7619060442EmailSt= yle20 {font-family:sans-serif;color:#1F497D;}#yiv7619060442 .yiv7619060442M= soChpDefault {font-size:10.0pt;}#yiv7619060442 filtered {margin:70.85pt 70.= 85pt 70.85pt 70.85pt;}#yiv7619060442 div.yiv7619060442WordSection1 {}#yiv76= 19060442 A new line I got now. =C2=A0 # DROP TABLE caprimeta.tcr_codes CAS= CADE; ERROR:=C2=A0 XX000: cache lookup failed for relation 49179 LOCATION:= =C2=A0 heap_drop_with_catalog, heap.c:1773 =C2=A0 From: Bhattacharjee, Sou= mik Sent: Thursday, February 14, 2019 5:04 PM To: 'pgsql-admin@lists.postgresql.org' Cc: 'pgsql-admin@lists.postgresql.org' Subject: RE: Table Drop Error =C2=A0 Its not moving ahead with drop. =C2= =A0 # delete from pg_depend where objid=3D49179; DELETE 0 # delete from pg_= depend where objid=3D49179; DELETE 0 # DROP TABLE caprimeta.tcr_codes CASCA= DE; ERROR:=C2=A0 cache lookup failed for relation 49179 # =C2=A0 From: Bha= ttacharjee, Soumik Sent: Thursday, February 14, 2019 4:45 PM To: pgsql-admin@lists.postgresql.org Cc: pgsql-admin@lists.postgresql.org Subject: Table Drop Error =C2=A0 Hi All, =C2=A0 Any idea on this, it=E2= =80=99s kind of stuck here for me. =C2=A0 =C2=A0 # DROP TABLE caprimeta.t= cr_codes CASCADE; =C2=A0 ERROR:=C2=A0 cache lookup failed for relation 491= 79 =C2=A0 =C2=A0 Thanks Soumik=20 =20 ------=_Part_1040571_1704931771.1550164768684 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I think you have something= link to that table.

I do have this issue before and I removed oid, obji= d and conrelid 1st before drop the table

do o= btain oid of the table:

select oid from pg_class c join pg_n= amespace n
on n.oid =3D c.relnamespace where c.relname =3D'<table_n= ame>' and n.nspname =3D '<schema name>';

=
then delete oid, objid and conrelid:

de= lete from pg_class where oid =3D <oid number>;
delete from pg_de= pend where objid =3D <oid number>;
delete from pg_constraint whe= re conrelid =3D <oid number>;

finally = drop your schema's table with cascade;

<= /div>
 
<= b id=3D"yiv7619060442yui_3_13_0_rc_1_16_1381789421038_18">Bach-Nga

No one in this world is pure and perfect.&= nbsp; If you avoid people for their mistakes you will be alone. So judge le= ss, love and forgive more.
= To call hi= m a dog hardly seems to do him justice though in as much as he had four leg= s, a tail, and barked, I admit he was, to all outward appearances. But to t= hose who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply= **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Shar= ing success


On Thursday, February 14, 2019 11:52 AM, "soumik.= bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.com> wrote:


A new line I got now.
=20
 
=20
# DROP TABLE caprimeta.tcr_codes CASCADE;
=20
ERROR:  XX000: cache lookup failed for relation 49179
=20
LOCATION:  heap_drop_with_catalog, heap.c:1773
=20
 
=20
From: Bhattacharjee, Soumik
Sent: Thursday, February 14, 2019 5:04 PM
To: 'pgsql-admin@lists.postgresql.org' <pgsql-admin@lists.postgre= sql.org>
Cc: 'pgsql-admin@lists.postgresql.org' <pgsql-admin@lists.postgre= sql.org>
Subject: RE: Table Drop Error
=20
 
=20
Its not moving ahead with drop.
=20
 
=20
# delete from pg_depend where objid=3D49179;
=20
DELETE 0
=20
# delete from pg_depend where objid=3D49179;
=20
DELETE 0
=20
# DROP TABLE caprimeta.tcr_codes CASCADE;
=20
ERROR:  cache lookup failed for relation 49179=20
#
=20
 
=20
From: Bhattacharjee, Soumik
Sent: Thursday, February 14, 2019 4:45 PM
To: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@lists.postgresql.org
Subject: Table Drop Error
=20
 
=20
Hi = All,
=20
&n= bsp;
=20
Any idea on this, it=E2=80=99s kind of stuck here for me.
=20
 
=20
 
=20
# DROP TABLE caprimeta.tcr_codes CASCADE;
=20
 
=20
ERROR:  cache lookup failed for relation 49179=20
 
=20
 
=20
Thanks
=20
Soumik
=20


------=_Part_1040571_1704931771.1550164768684--