Re: Cannot read back pg_dump from 7.2 into 7.4

Oops, last message was not entirely correct: Unfortunately the 7.2 version
is also unable to read back the dumps it made. The dumps created look
completely impossible to run to me:

line100: create view "vw1" as select field1 from table1;

line200: create table1 (field1 integer);

If the server went down today, I'd be in big trouble! Please help!

Gerwin

"Gerwin Philippo" <gerwin(at)vernet(dot)nl> schreef in bericht
news:3fc1eecd$0$1508$e4fe514c(at)news(dot)xs4all(dot)nl(dot)(dot)(dot)
> I'm testing 7.4, and tried to read a pg_dump file created in 7.2 into a
7.4
> database.
> I get a lot of error messages when creating views from tables because the
> tables are not created yet.
> Looking into the dump file, the order in which objects are created looks
> funny: first some views, then the tables on which these views are based.
> This seems impossible to me, but the odd thing is that with the 7.2 server
I
> can read this dump into a new database without any problems.
> Any ideas?
>
>