'Bad timestamp external representation' error when restoring database
От | Søren Neigaard |
---|---|
Тема | 'Bad timestamp external representation' error when restoring database |
Дата | |
Msg-id | 006101c253ee$381dbcb0$200110ac@mt45neigaard обсуждение исходный текст |
Ответы |
Re: 'Bad timestamp external representation' error when restoring database
|
Список | 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.neigaard@mobilethink.dk Web: www.mobilethink.dk ................................
В списке pgsql-general по дате отправления: