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 C9C7DD9B66
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Oct 2005 05:58:20 -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 60279-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 10 Oct 2005 08:58:17 +0000 (GMT)
Received: from mail.nsasia.co.th (mail.nsasia.co.th [203.146.6.34])
	by svr1.postgresql.org (Postfix) with ESMTP id 8CE85D9B50
	for <pgsql-sql@postgresql.org>; Mon, 10 Oct 2005 05:58:17 -0300 (ADT)
Received: from [192.168.200.39] (helo=mail.nsasia.co.th)
	by astaro.nsasia.co.th with esmtp (Exim 4.43) id 1EOtUB-00006T-9a
	for pgsql-sql@postgresql.org; Mon, 10 Oct 2005 15:58:19 +0700
Received: from Thailand-MTA by mail.nsasia.co.th
	with Novell_GroupWise; Mon, 10 Oct 2005 15:57:59 +0700
Message-Id: <434A8F85.C5F7.004C.0@nsasia.co.th>
X-Mailer: Novell GroupWise Internet Agent 7.0 
Date: Mon, 10 Oct 2005 15:57:53 +0700
From: "Premsun Choltanwanich" <Premsun@nsasia.co.th>
To: "Richard Huxton" <dev@archonet.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: How to delete Large Object from Database?
References: <43465BAA.C5F7.004C.0@nsasia.co.th>
 <434623FD.7000408@archonet.com>
In-Reply-To: <434623FD.7000408@archonet.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="=__Part4D6F4901.1__="
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.074 required=5 tests=[AWL=0.017, HTML_30_40=0.056,
	HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200510/77
X-Sequence-Number: 22930

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=__Part4D6F4901.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

The lib I use is call lo_in and lo_out for manage BLOB.
=20
I understand that lo_unlink be related with lo_import and lo_export so I =
don't think that it work.


>>> Richard Huxton <dev@archonet.com> 07-Oct-05 14:30:05 pm >>>
Premsun Choltanwanich wrote:
>=20
> Dear All,
> =20
> I use '$libdir/lo' for manage my PostgreSQL Large Object. It work =
fine=20
> for me to get and put Large Object  from and to database. However I=20
> found something that may not correct when I try to backup my data. It=20
> seem that I cannot delete Large Object from database. It seem the =
thing=20
> I can do is only delete the reference oid from table but Object still =
in=20
> 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=20
lo_unlink() in Chapter 28 of the manuals.

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

--=20
   Richard Huxton
   Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match


--=__Part4D6F4901.1__=
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-874=
">
<META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Microsoft Sans Serif">
<DIV>The lib I use is call lo_in and lo_out for manage BLOB.</DIV>
<DIV>&nbsp;</DIV>
<DIV>I understand that lo_unlink be related with lo_import and lo_export =
so I don't think that it work.</DIV><BR><BR>&gt;&gt;&gt; Richard Huxton =
&lt;dev@archonet.com&gt; 07-Oct-05 14:30:05 pm &gt;&gt;&gt;<BR>Premsun =
Choltanwanich wrote:<BR>&gt; <BR>&gt; Dear All,<BR>&gt;&nbsp; <BR>&gt; I =
use '$libdir/lo' for manage my PostgreSQL Large Object. It work fine =
<BR>&gt; for me to get and put Large Object&nbsp; from and to database. =
However I <BR>&gt; found something that may not correct when I try to =
backup my data. It <BR>&gt; seem that I cannot delete Large Object from =
database. It seem the thing <BR>&gt; I can do is only delete the reference =
oid from table but Object still in <BR>&gt; database.<BR><BR>&gt; So,How =
to delete Large Object from Database? or Is my understanding wrong?<BR><BR>=
Deleting the OID does not remove the object itself - see details of =
<BR>lo_unlink() in Chapter 28 of the manuals.<BR><BR>I seem to recall some =
other utilities in the contrib/ directory of the <BR>source distribution =
too.<BR><BR>-- <BR>&nbsp;&nbsp; Richard Huxton<BR>&nbsp;&nbsp; Archonet =
Ltd<BR><BR>---------------------------(end of broadcast)-------------------=
--------<BR>TIP 9: In versions below 8.0, the planner will ignore your =
desire to<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; choose an index scan if =
your joining column's datatypes do not<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp; match<BR></BODY></HTML>

--=__Part4D6F4901.1__=--