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
>
>