"Silvela, Jaime \(Exchange\)" <JSilvela@xxxxxxxx> 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
