From: Armel HERVE <ah.pgsql@laposte.net>
To: pgsql-interfaces@postgresql.org
Subject: Problem with pg_dump / pg_restore
Date: Mon, 24 Nov 2003 15:02:26 +0100
Message-ID: <CGEBLCNHICNOBNMINIICIEADCDAA.ah.pgsql@laposte.net> (raw)
Hi everybody,
I have a problem with dump / restore commands on PostgreSQL:
pg_dump doesn't care about objects dependencies:
- I create a view V1 on a table and then another view V2 on the
same table
- I modify V1 to use V2
pg_dump doesn't detect that V1 is using V2. So the command batch
generated contains in first the creation of the view V1 which uses V2
and then the creation on the view V2 and it's impossible to restore a
database with this generated file.
My question is : how can I use pg_dump / pg_restore to generate a good
backup file ?
Thanks for your answers (and sorry for my poor english!!!)
Armel
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ah.pgsql@laposte.net
Subject: Re: Problem with pg_dump / pg_restore
In-Reply-To: <CGEBLCNHICNOBNMINIICIEADCDAA.ah.pgsql@laposte.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox