Re: CASCADING could not open relation with OID

"Silvela, Jaime \(Exchange\)" <JSilvela(at)Bear(dot)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