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: 485A985A.10404@computer.org (view raw or flat)
Thread:
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).

David

In response to

Responses

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-2014 The PostgreSQL Global Development Group