Well, I dumped the database from two different versions of Postgres (on different machines), using both pg_dump 8.0.0beta2 and pg_dump 7.4.2 (which correspond to the respective server versions). I only restored on the 8.0.0beta machine, though. Would that make a difference?
I will also poke around in my database to see if perhaps something else is blocking a proper dump.
Thanks,
EE
Michael Fuhr wrote:
On Thu, Jan 06, 2005 at 12:10:26PM -0500, Eric E wrote:
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.
What version of PostgreSQL are you using? pg_dump tends to improve with each release; I couldn't duplicate your problem in 8.0.0rc3 or 7.4.6.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
