From: pawan shirbhate <pawanshirbhate@googlemail.com>
To: Adam Radlowski <adamr@informatyka.gdansk.pl>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Error : could not send data to server: Error 0
Date: Tue, 30 Oct 2007 18:32:00 +0530
Message-ID: <65f669c80710300602u480a40bcmea98f53e7d3dc7fd@mail.gmail.com> (raw)
In-Reply-To: <4727040F.3030903@informatyka.gdansk.pl>
References: <65f669c80710250347u71041650o12770fb85b230d4b@mail.gmail.com>
<4727040F.3030903@informatyka.gdansk.pl>
Hi Adam,
Thanks for your suggestion.
I am not getting that error when I tried to send data in smaller part. But,
the same program with 150000 records is running fine on Solaris 10 (Sparc
processor).
"could not send data to server: Error 0" - This error is thrown by libpq.
Is there any platform specific flags required to build libpq on x86 based
OS?
Regards,
Pawan
On 10/30/07, Adam Radlowski <adamr@informatyka.gdansk.pl> wrote:
>
> Maybe it's not good advice, but maybe You should divide Your data into
> smaller parts ?
> Brgds
> Adam
>
> pawan shirbhate wrote:
> > Hi,
> >
> > I am getting following error while sending the 15000 records using
> > PQputline() to postgreSQL DB.
> >
> > *could not send data to server: Error 0*
> >
> > Code snap:-
> >
> > strBuf =
> > "abc1798,2,26120,34760,653,869,60880,1522,05/24/2007,123456712";
> > strBuf += "\n";
> > printf("\n%s\n",strBuf.c_str());
> >
> > for(i=0;i<15000;i++)
> > {
> > /* Send a single row */
> > copy_result = PQputline(conn, strBuf.c_str());
> > if(copy_result != 0)
> > {
> > printf("\n%s\n", PQerrorMessage(conn));
> > }
> >
> > }
> >
> > copy_result = PQendcopy(conn);
> > if(copy_result != 0)
> > {
> > printf("\n%s\n", PQerrorMessage(conn));
> > }
> >
> > Platform - Solaris 10 (x86 based processor)
> > PostgreSQL version - 8.2.0
> > Interface - libpq
> > Application language - C/C++
> >
> > Appreciate help!!!
> >
> > Regards,
> > Pawan
> >
> >
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pawanshirbhate@googlemail.com, adamr@informatyka.gdansk.pl
Subject: Re: Error : could not send data to server: Error 0
In-Reply-To: <65f669c80710300602u480a40bcmea98f53e7d3dc7fd@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox