Re: JDBC and Blobs

From: David Wall <d.wall@computer.org>
Subject: Re: [JDBC] JDBC and Blobs
To: dev_hyd2001@yahoo.com
Cc: pgsql-jdbc@postgresql.org
Date: Thursday, June 19, 2008, 7:33 PM

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?

The JDBC driver should take care of creating and deleting the underlying LO.  However, with PG, the deleted LO isn't physically removed until you run contrib/vacuumlo.  We include vacuumlo in our daily db maintenance routines (pg_dump, vacuum, analyze, vacuumlo).

David