From: Premsun Choltanwanich <Premsun@nsasia.co.th>
To: pgsql-sql@postgresql.org
Subject: How to delete Large Object from Database?
Date: Fri, 07 Oct 2005 11:27:40 +0700
Message-ID: <43465BAA.C5F7.004C.0@nsasia.co.th> (raw)
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.
A Detail shown below is reason I think that I cannot delete Large Object out of database.
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)
So,How to delete Large Object from Database? or Is my understanding wrong?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Premsun@nsasia.co.th
Subject: Re: How to delete Large Object from Database?
In-Reply-To: <43465BAA.C5F7.004C.0@nsasia.co.th>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox