Обсуждение: 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
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
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
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
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
<soumik.bhattacharjee@kpn.com> 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
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 <tgl@sss.pgh.pa.us> Sent: Friday, February 15, 2019 5:03 PM To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com> Cc: pgsql-admin@lists.postgresql.org Subject: Re: Table Drop Error <soumik.bhattacharjee@kpn.com> 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
soumik.bhattacharjee@kpn.com wrote: > From: Tom Lane <tgl@sss.pgh.pa.us> > > <soumik.bhattacharjee@kpn.com> 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 youdon'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
But what is the solution in this case? -----Original Message----- From: Laurenz Albe <laurenz.albe@cybertec.at> Sent: Sunday, February 17, 2019 8:35 PM To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; tgl@sss.pgh.pa.us Cc: pgsql-admin@lists.postgresql.org Subject: Re: Table Drop Error soumik.bhattacharjee@kpn.com wrote: > From: Tom Lane <tgl@sss.pgh.pa.us> > > <soumik.bhattacharjee@kpn.com> 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 youdon'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
soumik.bhattacharjee@kpn.com wrote: > But what is the solution in this case? Before we can come up with a solution, we have to understand the problem. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com