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