Postgres Pro
Downloads
Home   >   mailing lists

Re: Table Drop Error - Mailing list pgsql-admin

From Pepe TD Vo
Subject Re: Table Drop Error
Date
Msg-id 1399539471.1040572.1550164768687@mail.yahoo.com
Whole thread Raw
In response to Table Drop Error  (<soumik.bhattacharjee@kpn.com>)
List pgsql-admin
Tree view
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 n
on 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.bhattacharjee@kpn.com" <soumik.bhattacharjee@kpn.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@lists.postgresql.org' <pgsql-admin@lists.postgresql.org>
Cc: 'pgsql-admin@lists.postgresql.org' <pgsql-admin@lists.postgresql.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@lists.postgresql.org
Cc: pgsql-admin@lists.postgresql.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


pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Table Drop Error
Next
From: Azman Kudus
Date:
Subject: pgAdmin startup error : Segmentation fault (core dumped)