pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

pg_dumpall
2+ messages / 1 participants
[nested] [flat]

* pg_dumpall
@ 2002-05-13 21:28 Oleg Lebedev <olebedev@waterford.org>
  2002-05-14 22:15 ` Re: pg_dumpall Oleg Lebedev <olebedev@waterford.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Oleg Lebedev @ 2002-05-13 21:28 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_dumpall
  2002-05-13 21:28 pg_dumpall Oleg Lebedev <olebedev@waterford.org>
@ 2002-05-14 22:15 ` Oleg Lebedev <olebedev@waterford.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Oleg Lebedev @ 2002-05-14 22:15 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2002-05-14 22:15 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-05-13 21:28 pg_dumpall Oleg Lebedev <olebedev@waterford.org>
2002-05-14 22:15 ` Oleg Lebedev <olebedev@waterford.org>

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