Thread: Deleting blob data with LargeObject Java API

Deleting blob data with LargeObject Java API

From

"David Benoff"

Date:

12 October 2003, 16:41:59

Hi all,

I’m using the JDBC LargeObject api to do CRUD operations with blobs stored in pg_largeobject. I am hoping someone could clarify whether calling lobj.delete(myoid) performs a physical or just a logical delete. If I want to completely delete the blob data from the DB (physical delete), can I just use lobj.delete, or do I have to write a function/trigger to call lo_unlink? If I DO have to call lo_unlink, does anyone know where I could find example code (since I assume this is a common issue)?

Thanks,

David Benoff

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003

Off Topic

From

"Bob Jarman"

Date:

14 October 2003, 16:42:27

Has the PostgreSQL.org website been taken down - I get an Apache "Successful Installation" page...

Bob Jarman

Re: Off Topic

From

Bryan Irvine

Date:

14 October 2003, 16:49:19

seems to work now.

--Bryan

On Mon, 2003-10-13 at 11:19, Bob Jarman wrote:
> Has the PostgreSQL.org website been taken down - I get an Apache
> "Successful Installation" page...
>
> Bob Jarman
>