From: | Oleg Lebedev <olebedev(at)waterford(dot)org> |
---|---|
To: | Postgres SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall |
Date: | 2002-05-14 22:15:00 |
Message-ID: | 3CE18C64.B2EEB710@waterford.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Royston | 2002-05-14 23:02:41 | Re: [SQL] can't cast varchar as integer? |
Previous Message | David Stanaway | 2002-05-14 21:47:39 | Re: can't cast varchar as integer? |