Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBH1fsm49316 for ; Sun, 16 Dec 2001 20:41:54 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id BF420D5E8; Sun, 16 Dec 2001 17:41:57 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id B4F375BF1; Sun, 16 Dec 2001 17:41:57 -0800 (PST) Date: Sun, 16 Dec 2001 17:41:57 -0800 (PST) From: Stephan Szabo To: Terrence Brannon Cc: Subject: Re: What happens if you delete a row containing a BLOB? In-Reply-To: <95F37F74-F25C-11D5-92F7-003065C2A10C@mac.com> Message-ID: <20011216173020.V45389-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/167 X-Sequence-Number: 5990 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.