Re: JDBC and Blobs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: dev_hyd2001(at)yahoo(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC and Blobs
Date: 2008-06-19 14:43:28
Message-ID: 12347.1213886608@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

"Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> writes:
> Dev wrote:
>> If I delete a row in that table , will it delete the binary data
>> as well from the database server?

> No; the best way would be to create a trigger on the table that
> will delete the large object if you delete (or change) the
> OID in the table row.

See contrib/lo rather than reinventing that wheel for yourself ...

regards, tom lane

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message David Wall 2008-06-19 17:33:14 Re: JDBC and Blobs
Previous Message Albe Laurenz 2008-06-19 13:34:15 Re: JDBC and Blobs