Re: cache lookup failed for attribute 1 of relation XXXXXX

2018-07-19 Thread Alessandro Aste
Thanks much, I'll keep my eyes open today night hoping it will not happen again. On Thu, Jul 19, 2018 at 5:39 PM, Tom Lane wrote: > [ please keep the list cc'd for the archives' sake ] > > Alessandro Aste writes: > > Hello Tom, thanks for your reply: > > SELECT * FROM pg_class WHERE OID = 222

Re: cache lookup failed for attribute 1 of relation XXXXXX

2018-07-19 Thread Tom Lane
[ please keep the list cc'd for the archives' sake ] Alessandro Aste writes: > Hello Tom, thanks for your reply: > SELECT * FROM pg_class WHERE OID = 2223152859 ; > (0 rows) > I'm not aware of any DDL at that time. Hm. Well, that OID was definitely there when pg_dump looked, and it's not ther

Re: cache lookup failed for attribute 1 of relation XXXXXX

2018-07-19 Thread Tom Lane
Alessandro Aste writes: > pg_dump: [archiver (db)] query failed: ERROR: cache lookup failed for > attribute 1 of relation 2223152859 > pg_dump: [archiver (db)] query was: SELECT t.tableoid, t.oid, t.relname > AS indexname, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, > t.relnatts AS