RE: libpq problem with inserts - Mailing list pgsql-general

From Kevin Sorensen
Subject RE: libpq problem with inserts
Date
Msg-id LNBBLFDKDBGPNAIBMDLNEEPACKAA.kevin@pcxcess.com
Whole thread Raw
In response to Re: libpq problem with inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
sorry, no. as for the data that i am inserting, most of it is just numbers
as the script is to run invoicing on customers in the database. and it runs
through the loop several times, and just leaves out some of the entries when
looping through. i was reading about the synchronous, asynchronous methods
in libpq, but it just confused me more. heh, no sleep for me last night,
maybe
that is it.

kevin

-----Original Message-----
From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of Tom Lane
Sent: Friday, September 08, 2000 9:12 AM
To: Kevin Sorensen
Cc: pgsql-general@hub.org
Subject: Re: [GENERAL] libpq problem with inserts


"Kevin Sorensen" <kevin@pcxcess.com> writes:
> i am running a loop inserting several items into a table something kind
> of similar as below, but more complicated. However, when i print the sql
> strings, everything prints out and works fine, however, when i try to
> insert them into the database, only some of them get inserted.

Any quote marks or backslashes in the data you're inserting?

            regards, tom lane


pgsql-general by date:

Previous
From: lee johnson
Date:
Subject: Re: postgres not allowing new database?
Next
From: "Pablo Prieto"
Date:
Subject: Minutes in an interval