Received: from maciek.gv.edu.pl (root@netserv.gv.edu.pl [195.117.86.8]) by
	hub.org (8.8.8/8.7.5) with ESMTP id QAA24414 for
	<pgsql-interfaces@hub.org>; Wed, 19 Aug 1998 16:44:42 -0400 (EDT)
Received: from andrzej (pppa74.kielce.tpnet.pl [195.116.245.74])
	by maciek.gv.edu.pl (8.8.8/8.8.8) with SMTP id WAA17687;
	Wed, 19 Aug 1998 22:41:47 GMT (envelope-from andrzej@gv.edu.pl)
Message-Id: <199808192241.WAA17687@maciek.gv.edu.pl>
Comments: Authenticated sender is <anmail@[195.117.86.8]>
From: "Andrzej Szydlo" <andrzej@gv.edu.pl>
To: Byron Nikolaidis <byronn@insightdist.com>
Date: Wed, 19 Aug 1998 22:53:54 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Re: [INTERFACES] ODBC, Delphi and BLOBs (images)
CC: pgsql-interfaces@hub.org
Priority: normal
In-reply-to: <Pine.BSF.3.96.980819221023.17484A-100000@maciek.gv.edu.pl>
X-mailer: Pegasus Mail for Win32 (v2.54)

On Wed, 19 Aug 1998 at 15:17:36 -0400, Byron Nikolaidis wrote:

> 
> But what did you get in your log file this time?  It should have a different
> message.

I'm sorry for not attaching it.

There are two cases. The first one I described in my previous 
message. There's no activity logged then and Delphi displays "Invalid 
BLOB length", nothing is written to tha table. It happens when I try 
to insert a large image.

When I try to insert a relatively small image:
++++++++++
conn=43911292, query='declare SQL_CUR44066004 cursor for SELECT "img"
FROM "test_tab" WHERE "nr"=3' conn=43911292, query='fetch 100 in
SQL_CUR44066004'
    [ fetched 1 rows ]
    STATEMENT ERROR: func=SQLFetch, desc='', errnum=1, errmsg='Couldnt
    open large object for writing.'
++++++++++

Delphi displays:
"Read Error: Couldn't open large object for writing."

and only the "nr" field is written to the table.

( the table is:
CREATE TABLE test_tab(nr int4, img lo);
CREATE UNIQUE INDEX test_inx ON test_tab (nr); )

Andrzej