Re: pg_restore and materialized view deps

Wells Oliver <wells.oliver@gmail.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