Re: Table Drop Error

[Pepe TD Vo <pepevo@xxxxxxxxx>]

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@xxxxxxx" <soumik.bhattacharjee@xxxxxxx> wrote:

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@xxxxxxxxxxxxxxxxxxxx' <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Cc: 'pgsql-admin@xxxxxxxxxxxxxxxxxxxx' <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxxx
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
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