> 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 Nasato||Date: 2008-06-20 09:01:54|
|Subject: preprocessing of sql in the jdbc driver|
|Previous:||From: Tom Lane||Date: 2008-06-19 14:43:28|
|Subject: Re: JDBC and Blobs |