Re: CASCADING could not open relation with OID - Mailing list pgsql-general

"Silvela, Jaime \(Exchange\)" <JSilvela@Bear.com> writes:
> If I try to read from one, I get ERROR:  could not open relation with
> OID 16896
> If I try to redefine it, I get ERROR:  relation "bb_master" already
> exists
> If I try to DROP it, ERROR:  cache lookup failed for relation 16896

What do you get from
    select oid, * from pg_class where relname = 'bb_master';
    select oid, * from pg_class where oid = 16896;

If either one fails to get a hit, try it again after doing
    set enable_indexscan = off;

> How can I get around this? What's happening?

Hard to tell.  It sounds a bit like pg_class catalog damage, but the
above experiment will tell us more.

            regards, tom lane