help with libpq program

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.

DAnn

My c code is one layer for wrap libpq.dll functions
i'm using function like

start with

PGresult *PQexec(PGconn *conn, const char *command);

command like 'copy foo from stdin ';

int PQputCopyData(PGconn *conn,
const char *buffer,
int nbytes);

(many times)
int PQputCopyEnd(PGconn *conn,
const char *errormsg);

I was sucessfull with append CSV

delimiter if not specified is tab character (from
documentation)

The problem was numeric formats, i can't find
solution for this but with CSV append was succesfull.
Thank for responses

Best regards
MDC

--- Dann Corbit <DCorbit@connx.com> escribi�:

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

---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please
send an appropriate
subscribe-nomail command to
majordomo@postgresql.org so that your
message can get through to the mailing list
cleanly

__________________________________________________
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