Re: help with libpq program - Mailing list pgsql-general

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