help with libpq program

From: marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: help with libpq program
Date: 2007-06-17 04:04:19
Message-ID: 990800.39396.qm@web32105.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-06-17 05:19:31 Re: What O/S or hardware feature would be useful for databases?
Previous Message Ottavio Campana 2007-06-17 01:58:28 Re: about cursors