Skip site navigation (1) Skip section navigation (2)

Upgrading 7.2.4 to 7.4.1

From: Jarmo Järvenpää <Jarmo(dot)Jarvenpaa(at)softers(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Upgrading 7.2.4 to 7.4.1
Date: 2004-02-16 12:59:26
Message-ID: 4030BEAE.8060108@softers.net (view raw or flat)
Thread:
Lists: pgsql-admin
Dear all,

I've got an old 7.2.4 DB which I hoped to upgrade to 7.4.1.
The old syntax used for creating tables had lines like
..
id integer DEFAULT '',

which translates to this error:

pg_restore: [archiver (db)] could not execute query: ERROR:  invalid 
input syntax for integer: ""

I found out that integer with '' as default is not acceptable after 7.3. 
  Also, some complaints were given with the data, particulary numerous 
"\N" lines when restoring (this can be worked out by using -d switch 
when dumping).

Also, schemas are not going to be created (some 7.3 documents gave this up).

Thus, must I update every DB creation script by hand and try to restore 
only the data?


Regards,
Jarmo


Responses

pgsql-admin by date

Next:From: Greg MennieDate: 2004-02-16 13:29:03
Subject: Re: hanging for 30sec when checkpointing
Previous:From: tsurkinDate: 2004-02-16 09:22:20
Subject: Re: SSH connection timing out

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group