When dealing with 'bigint'or 'int8', the command 'copy'doesn't work

Hi guys,

I meet a problem when try to import data from a Tab-delimited-text file to a table by command 'copy from'. A sample procedure is explained as follow,

first, I generate a file called /home/temp/test.txt, let's suppose it has only two lines, ( the four figures are delimited by tab)
123 456
789 999

Second, I type the following command under PSQL,
create table ttt ( c1 bigint, c2 bigint);

Finally, I try to import the data from test.txt into table ttt by,
copy ttt from '/home/temp/test.txt';

But I was told,
ERROR: copy: line 1, Bad int8 external representation "'123'"

(My PostgreSQL is v7.1)

I would appreciate any help or advice.

thanks in advance,

Dong, Meng
eddy(at)securities(dot)com