[ic] Importing tab-delimited file into Postgres fails

Rene Hertell interchange at hertell.com
Mon Nov 1 08:02:25 EST 2004


I have a tab-delimited file that I would need to reimport into an empty 
postgres table, but it fails with the following error:

[01/November/2004:13:14:34 +0200] - - set_row error: ERROR:  invalid 
input syntax for integer: ""
[01/November/2004:13:14:34 +0200] - - table 'tittelit' failed: tittelit 
import into  failed: set_row error: ERROR:  invalid input syntax for 
integer: "" at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1391.

My code-field (primary key) is an auto sequence field, and the rows I 
want to reimport have this value already set... I guess that this 
import-process does not work because of this...

Is there any workaround for this problem, or do I have create a table 
first without the sequence, and then add the sequence after importing 
the values?

Regards,

René




More information about the interchange-users mailing list