From: Adam Radłowski <adamr@informatyka.gdansk.pl>
To: pawan shirbhate <pawanshirbhate@googlemail.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Error : could not send data to server: Error 0
Date: Mon, 05 Nov 2007 05:35:33 +0100
Message-ID: <472E9D95.7090902@informatyka.gdansk.pl> (raw)
In-Reply-To: <65f669c80710300602u480a40bcmea98f53e7d3dc7fd@mail.gmail.com>
References: <65f669c80710250347u71041650o12770fb85b230d4b@mail.gmail.com>
<4727040F.3030903@informatyka.gdansk.pl>
<65f669c80710300602u480a40bcmea98f53e7d3dc7fd@mail.gmail.com>
...and I'm compiling libpq without any special flags, becouse my
programs are installed on not only by me installed clients and servers,
on shipped with Linux distributions of PostgreSQL, so I have to "keep
standards".
Regards
Adam
pawan shirbhate pisze:
> 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
> <mailto: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: adamr@informatyka.gdansk.pl, pawanshirbhate@googlemail.com
Subject: Re: Error : could not send data to server: Error 0
In-Reply-To: <472E9D95.7090902@informatyka.gdansk.pl>
* 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