How to delete Large Object from Database?

Поиск
Список
Период
Сортировка
От Premsun Choltanwanich
Тема How to delete Large Object from Database?
Дата
Msg-id 43465BA6.C5F7.004C.0@nsasia.co.th
обсуждение исходный текст
Ответы Re: How to delete Large Object from Database?  (Moises Alberto Lindo Gutarra <mlindo@gmail.com>)
Список pgsql-general
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?

В списке pgsql-general по дате отправления:

Предыдущее
От: suresh ramasamy
Дата:
Сообщение: Re: How to uninstall Postgres on Iinux.
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: PostgreSQL 8.1 vs. MySQL 5.0?