Date: Sat, 23 Feb 2002 15:31:32 -0500 From: "Dan Langille" <dan@langille.org> To: Carlo Dapor <carlo@vis.ethz.ch> Cc: freebsd-questions@freebsd.org, freebsd-database@freebsd.org Subject: Re: postgresql 7.1->7.2 data import timestamp problems Message-ID: <200202232031.g1NKVck44102@lists.unixathome.org> In-Reply-To: <E16eikK-0001ik-00@selonia.vis.ethz.ch> References: <200202231727.g1NHRYk42516@lists.unixathome.org> from "Dan Langille" at Feb 23, 2002 12:27:32 PM
next in thread | previous in thread | raw e-mail | index | archive | help
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-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200202232031.g1NKVck44102>