X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BED2DD1DF33 for ; Sun, 22 Feb 2004 02:09:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 77994-09 for ; Sat, 21 Feb 2004 22:09:42 -0400 (AST) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by svr1.postgresql.org (Postfix) with ESMTP id 35D85D1DF05 for ; Sat, 21 Feb 2004 22:09:38 -0400 (AST) Received: from [192.168.0.13] ([68.105.168.121]) by lakemtao04.cox.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20040222020943.KDTB19895.lakemtao04.cox.net@[192.168.0.13]>; Sat, 21 Feb 2004 21:09:43 -0500 From: Robert Treat To: Jarmo =?iso-8859-1?q?J=E4rvenp=E4=E4?= , pgsql-admin@postgresql.org Subject: Re: Upgrading 7.2.4 to 7.4.1 Date: Sat, 21 Feb 2004 21:09:39 -0500 User-Agent: KMail/1.5 References: <4030BEAE.8060108@softers.net> In-Reply-To: <4030BEAE.8060108@softers.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200402212109.39694.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/320 X-Sequence-Number: 12494 You might get better results using 7.4's pg_dump against the 7.2 database..= .=20 worth a try anyway. Robert Treat On Monday 16 February 2004 07:59, Jarmo J=E4rvenp=E4=E4 wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend --=20 Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL