From: Andrzej Szydlo <andrzej@gv.edu.pl>
To: Byron Nikolaidis <byronn@insightdist.com>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] ODBC, Delphi and BLOBs (images)
Date: Wed, 19 Aug 1998 22:53:54 +0100
Message-ID: <199808192241.WAA17687@maciek.gv.edu.pl> (raw)
In-Reply-To: <Pine.BSF.3.96.980819221023.17484A-100000@maciek.gv.edu.pl>
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
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: andrzej@gv.edu.pl, byronn@insightdist.com, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] ODBC, Delphi and BLOBs (images)
In-Reply-To: <199808192241.WAA17687@maciek.gv.edu.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