Postgres Pro
Downloads
Home   >   mailing lists

SQL Error: pqReadData() -- read() failed: errno=0 No error - Mailing list pgsql-cygwin

From Derrick Betts
Subject SQL Error: pqReadData() -- read() failed: errno=0 No error
Date
Msg-id 034601c37639$9eac20c0$e70a0a0a@BigOne
Whole thread Raw
List pgsql-cygwin
Tree view
I am a Postgres novice.  I have not done anything in the way of configuring
the DB differently from what the defaults are.

Here is my problem...
     I am sending the source text from web pages to the DB (7.3.2) through a
dataset in Delphi.  The field in the DB table is of the type "text", and the
fieldtype in Delphi shows ftMemo (a Blob type).  When I "ApplyUpdates" from
my application I get the "SQL Error: pqReadData() --  read() failed: errno=0
No error"  message.

Now, this is only happening when the length of the text that I am
attempting
to update to the DB is large.  On smaller text string sizes (i.e.. simple Web
Pages), I get no error and everything posts fine.

Is there some sort of setting that needs to be set for large "text" strings
on the DB, or is it likely to be an issue with the dataset - ApplyUpdates
procedure inside Delphi? I am using libpq72.dll to connect.

Is there a way to increase the buffer for incoming  requests?  Will this
help?


Thanks,
Derrick

pgsql-cygwin by date:

Previous
From: Patrick Bakker
Date:
Subject: Re: Windows XP SP1, PostgreSQL 7.2.4, Cygwin 1.3.22,
Next
From: a m
Date:
Subject: high cpu usage with postgres on windows XP