Postgres Pro
Downloads
Home   >   mailing lists

Re: Deleting LargeObjects as BLOBS - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Deleting LargeObjects as BLOBS
Date
Msg-id Pine.BSO.4.64.0801110032011.3943@leary.csoft.net
Whole thread Raw
In response to Deleting LargeObjects as BLOBS  (Jason Blumenkrantz <jason.blumenkrantz@onlinebankingsolutions.com>)
List pgsql-jdbc
Tree view 

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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: An I/O error occured while sending to the backend.
Next
From: Markus Riehl
Date:
Subject: Re: Autocommit Problem