Re: [GENERAL] ECPG and COPY and PQputCopyData - don't get errors

2006-02-26 Thread Wes
On 2/26/06 12:12 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > That just indicates that the data was sent to the backend without error. > You forgot to check the copy command result afterward. Ok, after re-reading the docs for the 10th time, I see I missed that I need to paragraph about calling 'PQ

Re: [GENERAL] ECPG and COPY and PQputCopyData - don't get errors

2006-02-26 Thread Tom Lane
Wes <[EMAIL PROTECTED]> writes: > I sent the column headers as the first line of the input. While this I now > know this is wrong, the problem here is that I got no error response back. > ... > However, every call to PQputCopyData, as well as PQputCopyEnd returned a > result of 1. That just indic

[GENERAL] ECPG and COPY and PQputCopyData - don't get errors

2006-02-25 Thread Wes
Since I can't use ECPG COPY, I'm trying to use libpq PQputCopyData. Not realizing I had to use CSV format to include column header names, I used: PQexec(conn, "COPY detail FROM stdin") I sent the column headers as the first line of the input. While this I now know this is wrong, the problem