I have set up a batch job that pipes a couple hundred of \copy commands to psql. It starts out well enough, sprinkled with a few error messages that I intend to circle back and clean up after batching all of the ALTER commands that I need, but then: \copy gm1 from export/month1-88/13m/GM1.dat csv psql:copy.sql:6328161: ERROR: invalid input syntax for integer: "743.5" CONTEXT: COPY gm1, line 415306, column gm1c: "743.5" \copy gm2a from export/month1-88/13m/GM2A.dat csv \copy gm2e from export/month1-88/13m/GM2E.dat csv \copy gm3 from export/month1-88/13m/GM3.dat csv \copy gm4 from export/month1-88/13m/GM4.dat csv psql:copy.sql:8059525: \copy: unexpected response (4) psql:copy.sql:8059525: \copy: unexpected response (4) psql:copy.sql:8059525: \copy: unexpected response (4) psql:copy.sql:8059525: \copy: unexpected response (4) psql:copy.sql:8059525: \copy: unexpected response (4) psql:copy.sql:8059525: \copy: unexpected response (4) psql:copy.sql:8059525: \copy: unexpected response (4) psql:copy.sql:8059525: \copy: unexpected response (4) . . . (I am echoing everything and interleaving stderr into a log file.) That last message is repeated literally ad inifinitum -- I mean I found 300G of them after leaving my job running overnight! I tried a \copy on that last file by hand and simply got another 'invalid input syntax' message. Can anyone speculate on what might lead to this condition? At first I thought it was a networking problem but doing what I could to minimize that possibility had no effect. Maybe I need to use separate connections? The only reference I could find to that error message was http://doxygen.postgresql.org/bin_2psql_2copy_8h.html but I know absolutely nil about the source code. Thanks. Neil -- View this message in context: http://www.nabble.com/%5Ccopy%3A-unexpected-response-%284%29-tp24866027p24866027.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
