From owner-freebsd-database Sat Feb 23 9:27:42 2002 Delivered-To: freebsd-database@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-database@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-database" in the body of the message From owner-freebsd-database Sat Feb 23 12:31:53 2002 Delivered-To: freebsd-database@freebsd.org Received: from lists.unixathome.org (lists.unixathome.org [210.48.103.158]) by hub.freebsd.org (Postfix) with ESMTP id DBF7137B400; Sat, 23 Feb 2002 12:31:46 -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 g1NKVck44102; Sun, 24 Feb 2002 09:31:39 +1300 (NZDT) (envelope-from dan@lists.unixathome.org) Message-Id: <200202232031.g1NKVck44102@lists.unixathome.org> From: "Dan Langille" Organization: DVL Software Limited To: Carlo Dapor Date: Sat, 23 Feb 2002 15:31:32 -0500 MIME-Version: 1.0 Subject: Re: postgresql 7.1->7.2 data import timestamp problems Reply-To: dan@langille.org Cc: freebsd-questions@freebsd.org, freebsd-database@freebsd.org References: <200202231727.g1NHRYk42516@lists.unixathome.org> from "Dan Langille" at Feb 23, 2002 12:27:32 PM In-reply-to: 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-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On 23 Feb 2002 at 21:26, Carlo Dapor wrote: > > > 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 > > In $PGSQL/doc/html/release.html You find the follwoing: > > A.1.2. Migration to version 7.2 > > A dump/restore using pg_dump is required for those wishing to migrate data from any previous release. > > [ . . . ] > > * > The date/time value 'current' is no longer available. You will need to rewrite your applications. > > > Are you using current date or something along the lines ? > Got to change that if it is the case. Yep, read that. That isn't the problem. The problem was a timestamp field which contained the value 'current' (honest! I didn't want that value in that field). Changing that to a true timestamp value fixed the problem. I'll update http://www.freebsddiary.org/postgresql-7.2.php later today. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Feb 23 13: 5:26 2002 Delivered-To: freebsd-database@freebsd.org Received: from primus.vsservices.com (primus.vsservices.com [63.66.136.75]) by hub.freebsd.org (Postfix) with ESMTP id B504637B423; Sat, 23 Feb 2002 13:05:16 -0800 (PST) Received: from prime.vsservices.com (conr-adsl-dhcp-26-38.txucom.net [209.34.26.38]) by primus.vsservices.com (8.11.3/8.11.3) with SMTP id g1NHsEk88727; Sat, 23 Feb 2002 11:54:14 -0600 (CST) (envelope-from gclarkii@vsservices.com) Date: Sat, 23 Feb 2002 11:54:17 -0600 From: GB Clark To: dan@langille.org Cc: freebsd-questions@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: postgresql 7.1->7.2 data import timestamp problems Message-Id: <20020223115417.1b750f1d.gclarkii@vsservices.com> In-Reply-To: <200202231727.g1NHRYk42516@lists.unixathome.org> References: <200202231727.g1NHRYk42516@lists.unixathome.org> X-Mailer: Sylpheed version 0.6.6 (GTK+ 1.2.10; i386-unknown-freebsd4.4) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Sat, 23 Feb 2002 12:27:32 -0500 "Dan Langille" wrote: > 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 Dan, This has been discussed on the PostgreSQL lists. It has something to due with all of the time/date changes between 7.1.? and 7.2. Check the archives for a cure. But I'm willing to bet that your using current to set a timestamp to a default time/date, right? You might try current_timestamp() instead and make sure it is not in quotes. I ran into a like problem after using timestamp as a field name...:) Not good. GB -- GB Clark II | Roaming FreeBSD Admin gclarkii@VSServices.COM | General Geek CTHULU for President - Why choose the lesser of two evils? To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message