Re: Table Drop Error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: soumik(dot)bhattacharjee(at)kpn(dot)com
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Table Drop Error
Date: 2019-02-15 16:02:51
Message-ID: 3681.1550246571@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<soumik(dot)bhattacharjee(at)kpn(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message soumik.bhattacharjee 2019-02-15 16:22:25 RE: Table Drop Error
Previous Message Achilleas Mantzios 2019-02-15 15:36:57 Re: help requested on archive_command