Postgres Pro
Downloads
Home   >   mailing lists

Re: Table Drop Error - Mailing list pgsql-admin

From Tom Lane
Subject Re: Table Drop Error
Date
Msg-id 3681.1550246571@sss.pgh.pa.us
Whole thread Raw
In response to RE: Table Drop Error  (<soumik.bhattacharjee@kpn.com>)
Responses RE: Table Drop Error  (<soumik.bhattacharjee@kpn.com>)
List pgsql-admin
Tree view 
<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

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: help requested on archive_command
Next
From:
Date:
Subject: RE: Table Drop Error