Re: What happens if you delete a row containing a BLOB?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Terrence Brannon <metaperl(at)mac(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: What happens if you delete a row containing a BLOB?
Date: 2001-12-17 01:41:57
Message-ID: 20011216173020.V45389-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Marc Spitzer 2001-12-17 02:01:06 Re: persistent connections, AOLserver (Was: maybe Offtopic :
Previous Message Tom Lane 2001-12-17 01:33:30 Re: why doesn't \d table_name show the table inheritance graph?