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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: eddy(at)securities(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: When dealing with 'bigint'or 'int8', the command 'copy'doesn't work
Date: 2001-08-01 14:44:19
Message-ID: 9598.996677059@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Dong, Meng" <eddy(at)securities(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-08-01 15:31:12 query first time works second time fails for one connection
Previous Message Wolfgang Winkler 2001-08-01 14:21:27 locale and german umlauts