X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 11817DA525
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Oct 2005 06:09:05 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 78553-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Oct 2005 09:08:56 +0000 (GMT)
Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75])
	by svr1.postgresql.org (Postfix) with ESMTP id DF346DA48E
	for <pgsql-sql@postgresql.org>; Fri,  7 Oct 2005 04:30:29 -0300 (ADT)
Received: from mainbox.archonet.com
	(84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99])
	by smtp.metronet.co.uk (MetroNet Mail) with ESMTP
	id 4A9C240C48A; Fri,  7 Oct 2005 08:30:25 +0100 (BST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP id 6510215EF9;
	Fri,  7 Oct 2005 08:30:16 +0100 (BST)
Received: from mainbox.archonet.com ([127.0.0.1])
	by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 09135-09; Fri, 7 Oct 2005 08:30:12 +0100 (BST)
Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP id E808815EDB;
	Fri,  7 Oct 2005 08:30:05 +0100 (BST)
Message-ID: <434623FD.7000408@archonet.com>
Date: Fri, 07 Oct 2005 08:30:05 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050912)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Premsun Choltanwanich <Premsun@nsasia.co.th>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to delete Large Object from Database?
References: <43465BAA.C5F7.004C.0@nsasia.co.th>
In-Reply-To: <43465BAA.C5F7.004C.0@nsasia.co.th>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.058 required=5 tests=[AWL=0.008,
	FORGED_RCVD_HELO=0.05]
X-Spam-Level: 
X-Archive-Number: 200510/71
X-Sequence-Number: 22924

Premsun Choltanwanich wrote:
> 
> Dear All,
>  
> I use '$libdir/lo' for manage my PostgreSQL Large Object. It work fine 
> for me to get and put Large Object  from and to database. However I 
> found something that may not correct when I try to backup my data. It 
> seem that I cannot delete Large Object from database. It seem the thing 
> I can do is only delete the reference oid from table but Object still in 
> database.

> So,How to delete Large Object from Database? or Is my understanding wrong?

Deleting the OID does not remove the object itself - see details of 
lo_unlink() in Chapter 28 of the manuals.

I seem to recall some other utilities in the contrib/ directory of the 
source distribution too.

-- 
   Richard Huxton
   Archonet Ltd