'Bad timestamp external representation' error when restoring database

From: Søren Neigaard <s(dot)neigaard(at)mobilethink(dot)dk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: 'Bad timestamp external representation' error when restoring database
Date: 2002-09-04 08:36:51
Message-ID: 006101c253ee$381dbcb0$200110ac@mt45neigaard
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have made a 'pg_dump database_name > dump_file' from a 7.1 database, and
then I tried a 'psql database_name < dump_file' on a empty 7.1 database. But
this gives me the following error:

--------- error ----------
You are now connected as new user postgres.
ERROR: ProcedureCreate: procedure plpgsql_call_handler already exists with
same arguments
ERROR: Language plpgsql already exists
You are now connected as new user dba.
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
CREATE
ERROR: copy: line 3580, Bad timestamp external representation '2002-08-23
08:31:60.00+02'
PQendcopy: resetting connection
--------- error ----------

Why do I get this error when I made the dump from a 7.1 to a 7.1, is that
not a bit strange? What can I do to work around this?

Med venlig hilsen/Best regards
Søren Neigaard
System Architect
................................
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 5.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
Email: s(dot)neigaard(at)mobilethink(dot)dk
Web: www.mobilethink.dk
................................

Responses

Browse pgsql-general by date

  From Date Subject
Next Message frbn 2002-09-04 09:23:56 Re: help please
Previous Message Søren Neigaard 2002-09-04 08:32:44 FIXED: Please help - Keep getting authentication failure when trying to restore database