Postgres Pro
Downloads
Home   >   mailing lists

copy 5.3000000000e+01 to bigint column error while Insert ok - Mailing list pgsql-general

From Jov
Subject copy 5.3000000000e+01 to bigint column error while Insert ok
Date
Msg-id CADyrUxPkg+8uLFygdSyazouy79fp7kMfu8u3q4-OxPm1ZXvJyg@mail.gmail.com
Whole thread Raw
Responses Re: copy 5.3000000000e+01 to bigint column error while Insert ok
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Matt
Date:
Subject: INSERT/UPDATE statements sometimes choosing not to use PK index?
Next
From: John R Pierce
Date:
Subject: Re: copy 5.3000000000e+01 to bigint column error while Insert ok