Thread: Cannot read back pg_dump from 7.2 into 7.4

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?

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@vernet.nl> schreef in bericht
news:3fc1eecd$0$1508$e4fe514c@news.xs4all.nl...
> 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?
>
>

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" <gerwin@vernet.nl> schreef in bericht
> news:3fc1eecd$0$1508$e4fe514c@news.xs4all.nl...
>
> > 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

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" <xzilla@users.sourceforge.net> schreef in bericht
news:200311241722.15996.xzilla@users.sourceforge.net...
> 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" <gerwin@vernet.nl> schreef in bericht
> > news:3fc1eecd$0$1508$e4fe514c@news.xs4all.nl...
> >
> > > 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 majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>