Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> Ah, you know, a little deeper: it's an issue with a mat view unable to
> refresh because it uses a function, and within that function, there is a
> call to a mat view not yet materialized.
Oh yes, pg_dump can't really see dependencies inside function bodies.
... Unless ... can you write the function as a new-style SQL
function (BEGIN ATOMIC instead of a string literal)?
Then I think it might work.
regards, tom lane