Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6])
	by hub.org (8.9.3/8.9.3) with ESMTP id TAA22346
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 20 Jun 1999 19:29:18 -0400 (EDT)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id TAA13177;
	Sun, 20 Jun 1999 19:28:03 -0400 (EDT)
To: "John Huttley" <john@mwk.co.nz>
cc: "PGSQL-Interfaces" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] libpq, large Objects 
In-reply-to: Your message of Mon, 21 Jun 1999 07:54:07 +1200
	<001401bebb56$a8787240$1401a8c0@Mr_Creosote.MWK.co.nz>
Date: Sun, 20 Jun 1999 19:28:03 -0400
Message-ID: <13175.929921283@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"John Huttley" <john@mwk.co.nz> writes:
> How do you destroy a large_object?

lo_unlink(oid_of_large_object)

> AFAIK, the only way to do it is to put its OID into a tuple in a table and
> then delete that tuple.

AFAIK, that will *not* remove the LO, just the referencing tuple ...

> How do you truncate a large_object?

I don't believe there's any way to do that.  It's an oversight, for
sure.

			regards, tom lane