From: | Eric E <whalesuit(at)bonbon(dot)net> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump dependencies |
Date: | 2005-01-06 18:26:47 |
Message-ID: | 41DD82E7.1010602@bonbon.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-01-06 18:39:16 | Re: Query, view join question. |
Previous Message | Joshua D. Drake | 2005-01-06 18:25:10 | Re: Question about varchar and text |