Re: BLOBs etc - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: BLOBs etc
Date
Msg-id 41DF02DB.9060707@opencloud.com
Whole thread Raw
In response to Re: BLOBs etc  (Thomas Hallgren <thhal@mailblocks.com>)
Responses Re: BLOBs etc  (Thomas Hallgren <thhal@mailblocks.com>)
List pgsql-jdbc
Thomas Hallgren wrote:
> Kris Jurka wrote:
>
>> That would work, but it's not going to happen.  Setting up and using a
>> large object is completely different than just stashing data in a bytea
>> field.  Convincing the server to do simple conversions is difficult
>> enough, getting it to do something of this magnitude is out of the
>> question.
>>
> Why? After all, both types represent a sequence of bytes so it's not
> really doing a conversion. It's just allowing multiple ways of accessing
> it.

The "different ways" involve different transaction semantics. You can't
currently deal with LOBs when autocommit is on. How would you deal with
that?

-O

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Driver Information-PostgreSQL 8
Next
From: Keith Hankin
Date:
Subject: Re: One byte integer support