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" <[EMAIL PROTECTED]> schreef in bericht news:[EMAIL PROTECTED] > 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? > > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
