Re: Table Drop Error

I think you have something link to that table.
I do have this issue before and I removed oid, objid and conrelid 1st before drop the table
do obtain oid of the table:
select oid from pg_class c join pg_namespace non n.oid = c.relnamespace where c.relname ='<table_name>' and n.nspname = '<schema name>';
then delete oid, objid and conrelid:
delete from pg_class where oid = <oid number>;delete from pg_depend where objid = <oid number>;delete from pg_constraint where conrelid = <oid number>;
finally drop your schema's table with cascade;
 Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their 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 to 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

On Thursday, February 14, 2019 11:52 AM, "soumik(dot)bhattacharjee(at)kpn(dot)com" <soumik(dot)bhattacharjee(at)kpn(dot)com> wrote:

#yiv7619060442 -- filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv7619060442 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv7619060442 p.yiv7619060442MsoNormal, #yiv7619060442 li.yiv7619060442MsoNormal, #yiv7619060442 div.yiv7619060442MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;}#yiv7619060442 a:link, #yiv7619060442 span.yiv7619060442MsoHyperlink {color:blue;text-decoration:underline;}#yiv7619060442 a:visited, #yiv7619060442 span.yiv7619060442MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv7619060442 p.yiv7619060442msonormal0, #yiv7619060442 li.yiv7619060442msonormal0, #yiv7619060442 div.yiv7619060442msonormal0 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;}#yiv7619060442 span.yiv7619060442EmailStyle18 {font-family:sans-serif;color:#1F497D;}#yiv7619060442 span.yiv7619060442EmailStyle19 {font-family:sans-serif;color:#1F497D;}#yiv7619060442 span.yiv7619060442EmailStyle20 {font-family:sans-serif;color:#1F497D;}#yiv7619060442 .yiv7619060442MsoChpDefault {font-size:10.0pt;}#yiv7619060442 filtered {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv7619060442 div.yiv7619060442WordSection1 {}#yiv7619060442 A new line I got now.   # DROP TABLE caprimeta.tcr_codes CASCADE; ERROR:  XX000: cache lookup failed for relation 49179 LOCATION:  heap_drop_with_catalog, heap.c:1773   From: Bhattacharjee, Soumik
Sent: Thursday, February 14, 2019 5:04 PM
To: 'pgsql-admin(at)lists(dot)postgresql(dot)org' <pgsql-admin(at)lists(dot)postgresql(dot)org>
Cc: 'pgsql-admin(at)lists(dot)postgresql(dot)org' <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: RE: Table Drop Error   Its not moving ahead with drop.   # delete from pg_depend where objid=49179; DELETE 0 # delete from pg_depend where objid=49179; DELETE 0 # DROP TABLE caprimeta.tcr_codes CASCADE; ERROR:  cache lookup failed for relation 49179 #   From: Bhattacharjee, Soumik
Sent: Thursday, February 14, 2019 4:45 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Table Drop Error   Hi All,   Any idea on this, it’s kind of stuck here for me.     # DROP TABLE caprimeta.tcr_codes CASCADE;   ERROR:  cache lookup failed for relation 49179     Thanks Soumik