Re: Deleting LargeObjects as BLOBS

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jason Blumenkrantz <jason(dot)blumenkrantz(at)onlinebankingsolutions(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Deleting LargeObjects as BLOBS
Date: 2008-01-11 05:33:54
Message-ID: Pine.BSO.4.64.0801110032011.3943@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 10 Jan 2008, Jason Blumenkrantz wrote:

> [how do I auto delete a blob when the row referring to it goes away]

The easiest thing to do is to define an AFTER DELETE trigger on your table
to cleanup the LO when the row goes away.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Markus Riehl 2008-01-11 05:36:50 Re: Autocommit Problem
Previous Message Kris Jurka 2008-01-11 05:31:41 Re: An I/O error occured while sending to the backend.