Postgres Pro
Downloads
Home   >   mailing lists

7.1->7.2 data import timestamp problems - Mailing list pgsql-admin

From Dan Langille
Subject 7.1->7.2 data import timestamp problems
Date
Msg-id 200202230559.g1N5xCk37026@lists.unixathome.org
Whole thread Raw
Responses Re: 7.1->7.2 data import timestamp problems
Re: 7.1->7.2 data import timestamp problems
List pgsql-admin
Tree view 
I'm importing the data from my 7.1.2 database into 7.2 and I've found
a few problems.

The first one was:

ERROR: Bad timestamp external representation 'current_timestamp'

I fixed that problem by removing the quotes within the input data.

The next problem seems slightly harder to fix.

$ psql fp2migration < fp2migration.sql.timestamp.library
[snip]
ERROR:  copy: line 2537, Bad timestamp external representation 'current'
lost synchronization with server, resetting connection
^C

Any clues as to what will fix this problem?
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

pgsql-admin by date:

Previous
From: "Dan Langille"
Date:
Subject: psql --single-step mode doesn't like empty sets
Next
From: "Gaetano Mendola"
Date:
Subject: Re: Building binary...