From owner-freebsd-questions Sat Feb 23 9:27:44 2002 Delivered-To: freebsd-questions@freebsd.org Received: from lists.unixathome.org (lists.unixathome.org [210.48.103.158]) by hub.freebsd.org (Postfix) with ESMTP id E9A0D37B400; Sat, 23 Feb 2002 09:27:37 -0800 (PST) Received: from wocker (lists.unixathome.org [210.48.103.158]) by lists.unixathome.org (8.11.6/8.11.6) with ESMTP id g1NHRYk42516; Sun, 24 Feb 2002 06:27:35 +1300 (NZDT) (envelope-from dan@lists.unixathome.org) Message-Id: <200202231727.g1NHRYk42516@lists.unixathome.org> From: "Dan Langille" Organization: DVL Software Limited To: freebsd-questions@freebsd.org Date: Sat, 23 Feb 2002 12:27:32 -0500 MIME-Version: 1.0 Subject: postgresql 7.1->7.2 data import timestamp problems Reply-To: dan@langille.org Cc: freebsd-database@freebsd.org X-mailer: Pegasus Mail for Windows (v4.01) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Just a heads up in case anyone is planning to upgrade to postgresql 7.2. I've found a few problems. The major problem, which is preventing me from upgrading is: $ psql fp2migration < fp2migration.sql [snip] ERROR: copy: line 2537, Bad timestamp external representation 'current' lost synchronization with server, resetting connection ^C Until I get that solved, I'll be staying on 7.1.2. I spent several hours on this already and have found no solution. This is definitly a migration issue as 7.1.2 accepts the data but 7.2 does not. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message