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@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of marcelo Cortez > Sent: Saturday, June 16, 2007 9:04 PM > To: pgsql-general@xxxxxxxxxxxxxx > 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
