Hi Michael,
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.
>
>
>
