Re: Odd pg dump error: cache lookup failure

On 2020-Aug-24, Wells Oliver wrote:

> 12.4. Both of those queries return no rows, with and without those options
> set.
> 
> We do do some nightly processing of data during the same window, in which
> views are re-materialized: would that cause this issue? No non-temporary
> tables are dropped or re-created, though.

Oh, so this could be some kind of relation that exists when pg_dump
starts but is dropped before it reaches the point where it dumps the
data for that relation.

Hmm.


-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services