A few thoughts: what command are you using to produce the 7.2 dump? what is the exact version of the 7.2 server?
Try and see if you can get a good dump using the 7.4 pg_dump against the 7.2 database. Robert Treat On Monday 24 November 2003 08:43, Gerwin Philippo wrote: > 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 -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
