Re: JDBC and Blobs - Mailing list pgsql-jdbc

From Albe Laurenz
Subject Re: JDBC and Blobs
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2023A99F2@exadv11.host.magwien.gv.at
Whole thread Raw
In response to JDBC and Blobs  (Dev <dev_hyd2001@yahoo.com>)
Responses Re: JDBC and Blobs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Dev wrote:
> I have a field in my database table of type OID which is
> suppose to be used to store binary data. I plan on using the
> setBlob and getBlob methods for storing and retrieving
> entries from the table. Is that the right way to proceed? If
> I delete a row in that table , will it delete the binary data
> as well from the database server?

No; the best way would be to create a trigger on the table that
will delete the large object if you delete (or change) the
OID in the table row.

This is of course only practical if the same large object
is not referenced by more than one table...

Yours,
Laurenz Albe

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: JDBC and Blobs
Next
From: Tom Lane
Date:
Subject: Re: JDBC and Blobs