7.1->7.2 data import timestamp problems

From: "Dan Langille" <dan(at)langille(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: 7.1->7.2 data import timestamp problems
Date: 2002-02-23 05:59:09
Message-ID: 200202230559.g1N5xCk37026@lists.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc 2002-02-23 11:37:45 Reset sequence number
Previous Message Dan Langille 2002-02-23 05:49:25 psql --single-step mode doesn't like empty sets