Postgres Pro
Downloads
Home   >   mailing lists

Re: What happens if you delete a row containing a BLOB? - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: What happens if you delete a row containing a BLOB?
Date
Msg-id 20011216173020.V45389-100000@megazone23.bigpanda.com
Whole thread Raw
In response to What happens if you delete a row containing a BLOB?  (Terrence Brannon <metaperl@mac.com>)
List pgsql-sql
Tree view 
On Sun, 16 Dec 2001, Terrence Brannon wrote:

> If you delete a row with a BLOB, does it automatically lo_unlink
> the blob?

IIRC, no, you'd need to make triggers in order to do that.  One thing
to be careful with is making sure that you don't have multiple references
to the large object before unlinking it.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: why doesn't \d table_name show the table inheritance graph?
Next
From: marc@oscar.eng.cv.net (Marc Spitzer)
Date:
Subject: Re: persistent connections, AOLserver (Was: maybe Offtopic :