Problem with pg_dump / pg_restore

From: "Armel HERVE" <ah(dot)pgsql(at)laposte(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problem with pg_dump / pg_restore
Date: 2003-11-28 10:55:32
Message-ID: CGEBLCNHICNOBNMINIICEECKCDAA.ah.pgsql@laposte.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi everybody,

I have already posted this message, but nobody answered to it.
I can't imagine that I'm the first one who have this problem, so
I post it again:

I have a problem with dump / restore commands on PostgreSQL:
pg_dump doesn't care about views dependencies:
- I create a view V1 on a table and then another view V2 on the
same table
- I modify V1 to use V2 and not directly the table

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 ?

Postgres versions : 7.4

Thanks for your answers (and sorry for my poor english!!!)

Armel

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message omkar prabhu 2003-11-28 11:43:41 PGDUMP BLOB PROBLEM
Previous Message Oli Sennhauser 2003-11-28 08:48:14 Re: server & client using different version, OK?