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 894F9D1DD17 for ; Mon, 16 Feb 2004 12:59:42 +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 10923-02 for ; Mon, 16 Feb 2004 08:59:44 -0400 (AST) Received: from mail.softers.net (softers.net [213.139.168.106]) by svr1.postgresql.org (Postfix) with SMTP id B840BD1D8F3 for ; Mon, 16 Feb 2004 08:59:39 -0400 (AST) Received: (qmail 3053 invoked by uid 0); 16 Feb 2004 12:59:26 -0000 Received: from unknown (HELO softers.net) (10.10.2.101) by 10.10.1.8 with SMTP; 16 Feb 2004 12:59:26 -0000 Message-ID: <4030BEAE.8060108@softers.net> Date: Mon, 16 Feb 2004 14:59:26 +0200 From: =?ISO-8859-15?Q?Jarmo_J=E4rvenp=E4=E4?= Organization: Softers Oy User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Upgrading 7.2.4 to 7.4.1 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/234 X-Sequence-Number: 12408 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