Thread: libpq problem with inserts

i have been reading most of the night trying to figure this out, and it
may be just because i am tired that i missed something but here is the
problem i am having:

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. i can say
that i am quite unfamiliar with libpq, but this one perl script is about
the only thing i have done with it, and it is for a cronjob. usually i use
php and have no problems. anyways, if anyone knows the answer or any ideas,
i would appreciated it.

postgresql v.7.0.0
rh linux 6.1

while ($i < 50) {
$blah1 = PQexec($conn, "INSERT INTO invoice_desc VALUES ('$val1', '$val2',
'$val3', '$val4');");
$blah2 = PQexec($conn, "INSERT INTO invoice_desc VALUES ('$val11', '$val12',
'$val13', '$val14');");
$blah3 = PQexec($conn, "INSERT INTO invoice_desc VALUES ('$val21', '$val22',
'$val23', '$val24');");
$blah4 = PQexec($conn, "INSERT INTO invoice_desc VALUES ('$val31', '$val32',
'$val33', '$val34');");
$i++;
}

my only guess is that some of the inserts are taking longer or something,
and it is just dropping them or something.

"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

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