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