Postgres Pro
Downloads
Home   >   mailing lists

Thread: Errors sending Blob to DB

Errors sending Blob to DB

From
"Derrick Betts"
Date:
I am using Delphi7 and PostgeSQL 7.3.2
 
My DB table is as such
    Create Table files (
emalid varchar(80),
memocolumn text,
savedfile oid );
 
I cannot post Blobs to the DB that are larger than a typical icon. If the Blob is small, it goes through just fine. When I try to send a larger object to the DB, I get a Postgres error:

SQL Error: pqReadData() - read() failed: errno=0

What am I doing wrong with this and what can I change to eliminate the error and get larger files into the database?

Thank you,
Derrick

Re: Errors sending Blob to DB

From
"Joshua D. Drake"
Date:
It would be helpful to see the code that you actually wrote. Just the part that initiates the transfer of the blob though.



Derrick Betts wrote:
I am using Delphi7 and PostgeSQL 7.3.2
 
My DB table is as such
    Create Table files (
emalid varchar(80),
memocolumn text,
savedfile oid );
 
I cannot post Blobs to the DB that are larger than a typical icon. If the Blob is small, it goes through just fine. When I try to send a larger object to the DB, I get a Postgres error:

SQL Error: pqReadData() - read() failed: errno=0

What am I doing wrong with this and what can I change to eliminate the error and get larger files into the database?

Thank you,
Derrick

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
The most reliable support for the most reliable Open Source database.