Where is your actual copy statement?
What is your field delimiter?
Why not post the actual C code for your program, if it is not too long?
I guess from what you have posted that the delimiter you supplied does not match the delimiter from your copy
statement.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of marcelo Cortez
> Sent: Saturday, June 16, 2007 9:04 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] help with libpq program
>
>
> folks
>
> i need help with libpq program ,i made on C program
> for
> wrapper libpq.dll program , the routine failing is
> copy from stdin interface.
>
> PQputCopyData return 1 (AKA ok)
> PQputCopyEnd return 1 (AKA ok)
> but nothing is append to database.
> tailing log file
>
> invalid input syntax for integer: "3 hello world
> 4.5
> "
> CONTEXT: COPY foo, line 1, column a: "3 hello
> world 4.5
> "
> STATEMENT: copy foo from stdin
>
> data seems to be correct
> "3\ hello world \ 4.5\n"
> "\\.\n"
>
> database ( is for one example found at google)
> create table foo (a int4, b char(16), d float8);
> copy foo from stdin;
>
> "3\ hello world \ 4.5\n"
> "\\.\n"
>
> I'm wrong?
>
> what is way to diagnose?
> any sugestion are welcomed
> best regards
>
> MDC
>
> PD: any example are welcomed too.
>
>
>
>
>
>
>
> __________________________________________________
> Preguntá. Respondé. Descubrí.
> Todo lo que querías saber, y lo que ni imaginabas,
> está en Yahoo! Respuestas (Beta).
> ¡Probalo ya!
> http://www.yahoo.com.ar/respuestas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend