[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