copy 5.3000000000e+01 to bigint column error while Insert ok

From: Jov <amutu(at)amutu(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: copy 5.3000000000e+01 to bigint column error while Insert ok
Date: 2013-10-29 06:34:40
Message-ID: CADyrUxPkg+8uLFygdSyazouy79fp7kMfu8u3q4-OxPm1ZXvJyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

when use insert command,we can insert 5.3000000000e+01 to table,but when
use copy command,we get this:
ERROR: invalid input syntax for integer: "'5.3000000000e+01'"
CONTEXT: COPY tdsort_metrics, line 1, column monitor_value:
"'5.3000000000e+01'"

any idea?

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-10-29 06:49:11 Re: copy 5.3000000000e+01 to bigint column error while Insert ok
Previous Message Matt 2013-10-29 06:16:43 INSERT/UPDATE statements sometimes choosing not to use PK index?