Thanks for the help, I found the problem(s). 1. There was always a problem with reading back dumps into an empty database in 7.2, and the views had to be done separately. The former admin had a file for that. When I ran that on a 7.2 database, things were fine. 2. When I tried this on the 7.4 database, it didn't work, because this database is more strict about typecasting. Wether this is the version or the config on the new server I don't know. Anyway, I had to rewrite the file with the view-definitions with some explicit type-casts, and then it worked. It was the combinations of these two things that tricked me.
Gerwin "Robert Treat" <[EMAIL PROTECTED]> schreef in bericht news:[EMAIL PROTECTED] > 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 > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
