7.1->7.2 data import timestamp problems

Поиск
Список
Период
Сортировка
От Dan Langille
Тема 7.1->7.2 data import timestamp problems
Дата
Msg-id 200202230559.g1N5xCk37026@lists.unixathome.org
обсуждение исходный текст
Ответы Re: 7.1->7.2 data import timestamp problems  (Peter Eisentraut <peter_e@gmx.net>)
Re: 7.1->7.2 data import timestamp problems  ("Dan Langille" <dan@langille.org>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Dan Langille"
Дата:
Сообщение: psql --single-step mode doesn't like empty sets
Следующее
От: "Gaetano Mendola"
Дата:
Сообщение: Re: Building binary...