Table Drop Error
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
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
RE: Table Drop Error
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
Re: Table Drop Error
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.
**Live simply **Love generously **Care deeply **Speak kindly.
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
Sent: Thursday, February 14, 2019 4:45 PM
To: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@lists.postgresql.org
Subject: Table Drop Error
RE: Table Drop Error
Hi All,
Anyone faced and solved below kind of issues?
Thanks
Soumik
From: Bhattacharjee, Soumik
Sent: Thursday, February 14, 2019 5:52 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
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
Re: Table Drop Error
writes: > # 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 It's not really a great idea to go dropping catalog rows without knowing exactly what you're doing, which I gather you don't. However ... are there pg_depend entries with refobjid=49179 ? regards, tom lane
RE: Table Drop Error
Hi Tom, Thanks for the mail, there is no entries in pg_depend as it returns " DELETE 0" But the table is not getting dropped. Thanks -----Original Message----- From: Tom Lane Sent: Friday, February 15, 2019 5:03 PM To: Bhattacharjee, Soumik Cc: pgsql-admin@lists.postgresql.org Subject: Re: Table Drop Error writes: > # 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 It's not really a great idea to go dropping catalog rows without knowing exactly what you're doing, which I gather you don't. However ... are there pg_depend entries with refobjid=49179 ? regards, tom lane
Re: Table Drop Error
soumik.bhattacharjee@kpn.com wrote: > From: Tom Lane > > writes: > > > # 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 > > > > It's not really a great idea to go dropping catalog rows without knowing exactly what you're doing, which I gather you don't. > > However ... are there pg_depend entries with refobjid=49179 ? > > Thanks for the mail, there is no entries in pg_depend as it returns " DELETE 0" > But the table is not getting dropped. Please read again. "refobjid=49179", not "objid=49179". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
RE: Table Drop Error
But what is the solution in this case? -----Original Message----- From: Laurenz Albe Sent: Sunday, February 17, 2019 8:35 PM To: Bhattacharjee, Soumik ; tgl@sss.pgh.pa.us Cc: pgsql-admin@lists.postgresql.org Subject: Re: Table Drop Error soumik.bhattacharjee@kpn.com wrote: > From: Tom Lane > > writes: > > > # 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 > > > > It's not really a great idea to go dropping catalog rows without knowing exactly what you're doing, which I gather you don't. > > However ... are there pg_depend entries with refobjid=49179 ? > > Thanks for the mail, there is no entries in pg_depend as it returns " DELETE 0" > But the table is not getting dropped. Please read again. "refobjid=49179", not "objid=49179". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com