Problème restore sur PostgreSql
Bonjour,
J'ai essayer de restorer d'un dump d'une base PostgreSql, et en cours du traitement la log m'envoie le message d'erreur ci-dessous :
Citation:
[18:07:45] Table # 24 'cat': starting transfer...
[XMLtoDB] SQL Message: ERROR: invalid input syntax for integer: "5.46885e+006"
[XMLtoDB] SQL Error: CONTEXT: COPY xxx_pg_stat, line 4, column n_prev_tup: "5.46885e+006" (Severity 1, Msg# 1).
[XMLtoDB] No SQL faulty command.
XMLtoDB: Error: Database BCP operation dbbcp_done failed on table test707_central.xxx_pg_stat
[18:07:45] table # 24 'cat': now transferred ( 1 rows transferred in 00h 00m 00s 140ms ).
[18:07:45] Whole transfer duration is 00h 00m 12s 916ms (for 133176 rows).
XMLtoDB: Transfer failed (XML -> DB) with message "XML data or another error occurred while reading file 'C:\Users\xxxx~1.xxx\AppData\Local\Temp\3\test707_central\test2_central.dat': Database BCP operation dbbcp_done failed on table test707_central.xxx_pg_stat.".
Quelqu'un à une idée sur le problème ...
SQL Message: ERROR: invalid input syntax for integer:
