Re: Streaming blob to db

How can I trigger the deletion of the large object when the row
containing the oid is deleted?

I mean I know that:
DELETE FROM pg_largeobject WHERE loid = nnn

But is there in jdbc, an automatic way to handle that?

Regards

Kuon

On Jul 4, 2005, at 11:33 AM, Kris Jurka wrote:

>
>
> On Fri, 1 Jul 2005, [UTF-8] æ^Y^Bæ^\^_ ç²¾é^\Š wrote:
>
>>
>> I got a web application that use jdbc and that will need to stream
>> binary data to the database.
>>
>> My application need an outputstream to send the data to the db, and
>> an inputstream to read the data from the db.
>>
>> I use postgresql 8.0.1 with bytea field.
>>
>>
>>> 100mb 20%
>>>
>>
>>
>
> If you are really dealing with 100+Mb files you should probably
> look into
> using large objects instead of bytea storage.  This will provide the
> streaming interfaces you are looking for and avoid excessive memory
> usage.
>
> http://jdbc.postgresql.org/documentation/80/binary-data.html
>
> Kris Jurka
>