pg_dump dependencies

From: Eric E <whalesuit(at)bonbon(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump dependencies
Date: 2005-01-06 17:10:26
Message-ID: 41DD7102.1030801@bonbon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stewart, Robert D (COT) 2005-01-06 17:25:20 Question about varchar and text
Previous Message Joost Kraaijeveld 2005-01-06 16:57:46 Re: Query, view join question.