Hi all,
I have a question about pg_dump. I am backing up a database using
pg_dump in text mode, which works perfectly for me, with one exception.
I have a view vwDependentView which references another view,
vwIndependentView. However, when I feed my dump script to psql, it is
attempting to make vwDependentView first and failing.
Short of editing the dump script manually, is there any way to force
checking these kinds of dependencies, or alternately manually specify
vwIndependentView to be restored before vwDependentView? Are there any
plans to implement this kind of behavior?
By the way, I presume this occurs because vwDependentView is ahead of
vwIndependentView alphabetically, so that to force vwDependentView to be
restored later, I could name it vwZDependentView. Is this correct?
Thanks,
Eric