Postgres Pro
Downloads
Home   >   mailing lists

Re: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work - Mailing list pgsql-bugs

From Tom Lane
Subject Re: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work
Date
Msg-id 9598.996677059@sss.pgh.pa.us
Whole thread Raw
In response to When dealing with 'bigint'or 'int8', the command 'copy'doesn't work  ("Dong, Meng" <eddy@securities.com>)
List pgsql-bugs
Tree view 
"Dong, Meng" <eddy@securities.com> writes:
> SGkgZ3V5cywNCg0KSSBtZWV0IGEgcHJvYmxlbSB3aGVuIHRyeSB0byBpbXBv
> cnQgZGF0YSBmcm9tIGEgVGFiLWRlbGltaXRlZC10ZXh0IGZpbGUgdG8gYSB0
> YWJsZSBieSBjb21tYW5kICdjb3B5IGZyb20nLiBBIHNhbXBsZSBwcm9jZWR1
> cmUgaXMgZXhwbGFpbmVkIGFzIGZvbGxvdywNCg0KDQpmaXJzdCwgSSBnZW5l
> cmF0ZSBhIGZpbGUgY2FsbGVkICAvaG9tZS90ZW1wL3Rlc3QudHh0LCBsZXQn
> [ etc ]

Please don't send HTML mail to the lists.

Although I'm not having any luck quoting your mail, I can tell
you that copying int8 values works fine for me.  If the error
message is spelled exactly as you show it, it suggests that's
what's really in your data file is not

    123    456

but

    '123'    '456'

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Dong, Meng"
Date:
Subject: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: query first time works second time fails for one connection