Re: JDBC and Blobs

Hi all,

Thanx for the responses. Looks like contrib/lo is the way to go !

cheers

/Dev

--- On Thu, 6/19/08, David Wall <d(dot)wall(at)computer(dot)org> wrote:
From: David Wall <d(dot)wall(at)computer(dot)org>
Subject: Re: [JDBC] JDBC and Blobs
To: dev_hyd2001(at)yahoo(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)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