Message-ID: <3CE18C64.B2EEB710@waterford.org>
Date: Tue, 14 May 2002 16:15:00 -0600
From: Oleg Lebedev <olebedev@waterford.org>
MIME-Version: 1.0
To: Postgres SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: pg_dumpall
References: <3CE02FF5.ABDC8CC@waterford.org>
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit

I figured it out.
It seems like I had a view VA defined in database A, which extracted data
from the table TA. I had to drop and recreate the table, so VA was
referencing the old table A. After that I exported data using dump_all. This
explains why psql wouldn't create view VA when importing data from a file
created by dump_all.

Is there a way to update all derived views when a table is dropped and then
created again?
thanks,

Oleg


> Hello,
> I am upgrading from Postgres7.1.3 to Postgres7.2.1 and dumped all the
> data to a file with
> pg_dumpall -o > dump
> When I go throught the dump file it turns out that some views are
> created before the base relations are created. When I try to import the
> dump file in Postgres 7.2.1 some of the views are not created because if
> this.
> Why the order of created data objects is wrong?
> I kept view definitions in several files, but I would still like to know
> how to move data between releases consistently.
> thanks,
>
> Oleg
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org