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 779BFD981D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Oct 2005 01:28:03 -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 22314-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Oct 2005 04:28:00 +0000 (GMT)
Received: from mail.nsasia.co.th (mail.nsasia.co.th [203.146.6.34])
	by svr1.postgresql.org (Postfix) with ESMTP id 8AE15DA471
	for <pgsql-sql@postgresql.org>; Fri,  7 Oct 2005 01:27:58 -0300 (ADT)
Received: from [192.168.200.39] (helo=mail.nsasia.co.th)
	by astaro.nsasia.co.th with esmtp (Exim 4.43) id 1ENjpr-0003dA-CD
	for pgsql-sql@postgresql.org; Fri, 07 Oct 2005 11:27:55 +0700
Received: from Thailand-MTA by mail.nsasia.co.th
	with Novell_GroupWise; Fri, 07 Oct 2005 11:27:45 +0700
Message-Id: <43465BAA.C5F7.004C.0@nsasia.co.th>
X-Mailer: Novell GroupWise Internet Agent 7.0 
Date: Fri, 07 Oct 2005 11:27:40 +0700
From: "Premsun Choltanwanich" <Premsun@nsasia.co.th>
To: <pgsql-sql@postgresql.org>
Subject: How to delete Large Object from Database?
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="=__PartBB99B02C.0__="
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.078 required=5 tests=[AWL=0.021, HTML_30_40=0.056,
	HTML_MESSAGE=0.001]
X-Spam-Level: 
X-Archive-Number: 200510/69
X-Sequence-Number: 22922

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.

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

Dear All,
=20
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.
=20
A Detail shown below is  reason I think that I cannot delete Large Object =
out of database.
=20
14MB of file size when BackUp Data (BLOB Included)
900KB of file size when BackUp Data (BLOB Excluded)
13MB of file size when BackUp Data after delete all data from table that =
has 'lo' column. (BLOB Included)=20
=20
So,How to delete Large Object from Database? or Is my understanding wrong?


--=__PartBB99B02C.0__=
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>Dear All,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I use '$libdir/lo' for manage my PostgreSQL Large Object. It work =
fine for me to get and put Large Object&nbsp; 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.</DIV>
<DIV>&nbsp;</DIV>
<DIV>A Detail shown below is&nbsp; reason I think that I cannot delete =
Large Object out of database.</DIV>
<DIV>&nbsp;</DIV>
<DIV>14MB of file size when BackUp Data (BLOB Included)</DIV>
<DIV>
<DIV>900KB of file size when BackUp Data (BLOB Excluded)</DIV>
<DIV>
<DIV>13MB of file size when BackUp Data after delete all data from table =
that has&nbsp;'lo' column.&nbsp;(BLOB Included)&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>So,How to delete Large Object from Database? or Is my understanding =
wrong?</DIV></DIV></DIV></BODY></HTML>

--=__PartBB99B02C.0__=--