RE: libpq problem with inserts

From: "Kevin Sorensen" <kevin(at)pcxcess(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)hub(dot)org>
Subject: RE: libpq problem with inserts
Date: 2000-09-08 14:46:02
Message-ID: LNBBLFDKDBGPNAIBMDLNEEPACKAA.kevin@pcxcess.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of Tom Lane
Sent: Friday, September 08, 2000 9:12 AM
To: Kevin Sorensen
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] libpq problem with inserts

"Kevin Sorensen" <kevin(at)pcxcess(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message lee johnson 2000-09-08 14:56:07 [Fwd: Re: postgres not allowing new database?]
Previous Message The Hermit Hacker 2000-09-08 14:44:32 Re: That killer 3rd join...