From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
cc: Stephen Frost <sfrost@snowman.net>,
        Alvaro Herrera <alvherre@2ndquadrant.com>,
        pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Odd pg dump error: cache lookup failure
In-reply-to: 
 <CAOC+FBVmcNR5d09YdNc_NG=b5_Y7OQmqbznJcGAt37U3wJxwpQ@mail.gmail.com>
References: 
 <CAOC+FBXosgRbSi-A+VLP8t5pmErEnP3M8aRJJ1z5HcyhvQM_eA@mail.gmail.com>
 <20200824231338.GA30623@alvherre.pgsql>
 <20200824231621.GA29590@tamriel.snowman.net>
 <2748788.1598376276@sss.pgh.pa.us>
 <CAOC+FBXXq_iDU9iFHUoL5F8PY8pZawiLQ1xuPq3VW9_RJcN0JQ@mail.gmail.com>
 <2760667.1598382327@sss.pgh.pa.us>
 <CAOC+FBVmcNR5d09YdNc_NG=b5_Y7OQmqbznJcGAt37U3wJxwpQ@mail.gmail.com>
Comments: In-reply-to Wells Oliver <wells.oliver@gmail.com>
	message dated "Tue, 25 Aug 2020 12:06:23 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2762014.1598384009.1@sss.pgh.pa.us>
Date: Tue, 25 Aug 2020 15:33:29 -0400
Message-ID: <2762015.1598384009@sss.pgh.pa.us>
Precedence: bulk

Wells Oliver <wells.oliver@gmail.com> writes:
> And refreshing materialized views during the dump process wouldn't cause
> this?

matviews can't be part of inheritance trees AFAIR, so we'd need some
other theory to explain it that way.

Did you try tracing down the table OID mentioned in the error to see
if it still exists, and if so what is it?

			regards, tom lane