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

Re: JDBC and Blobs

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: dev_hyd2001(at)yahoo(dot)com,"pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC and Blobs
Date: 2008-06-19 13:27:36
Message-ID: 485A5EC8.2030007@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-jdbc
Dev wrote:
> Hi,
> 
> 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?

I haven't used it myself, but my understanding is that deleting the row 
will NOT free the associated blob. The oid is only a reference to the blob.

You probably want the `lo' contrib module:

http://www.postgresql.org/docs/8.3/static/lo.html

--
Craig Ringer

In response to

pgsql-jdbc by date

Next:From: Albe LaurenzDate: 2008-06-19 13:34:15
Subject: Re: JDBC and Blobs
Previous:From: DevDate: 2008-06-19 09:18:57
Subject: JDBC and Blobs

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