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