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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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