From: Pepe TD Vo <pepevo@yahoo.com>
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Table Drop Error
Date: Thu, 14 Feb 2019 17:19:28 +0000 (UTC)
Message-ID: <1399539471.1040572.1550164768687@mail.yahoo.com> (raw)
References: <1399539471.1040572.1550164768687.ref@mail.yahoo.com>
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.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pepevo@yahoo.com, soumik.bhattacharjee@kpn.com, pgsql-admin@lists.postgresql.org
Subject: Re: Table Drop Error
In-Reply-To: <1399539471.1040572.1550164768687@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox