Skip site navigation (1) Skip section navigation (2)

Re: JDBC and Blobs

From: David Wall <d(dot)wall(at)computer(dot)org>
To: dev_hyd2001(at)yahoo(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC and Blobs
Date: 2008-06-19 17:33:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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?
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).


In response to


pgsql-jdbc by date

Next:From: Andrea NasatoDate: 2008-06-20 09:01:54
Subject: preprocessing of sql in the jdbc driver
Previous:From: Tom LaneDate: 2008-06-19 14:43:28
Subject: Re: JDBC and Blobs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group