From: | Moises Alberto Lindo Gutarra <mlindo(at)gmail(dot)com> |
---|---|
To: | Premsun Choltanwanich <Premsun(at)nsasia(dot)co(dot)th> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to delete Large Object from Database? |
Date: | 2005-10-07 11:40:12 |
Message-ID: | 5db591c00510070440r53a28e29v@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
try: delete from pg_catalog.pg_largeobject;
from your database.
2005/10/6, Premsun Choltanwanich <Premsun(at)nsasia(dot)co(dot)th>:
> 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?
--
Atte
Moises Alberto Lindo Gutarra
Consultor y Desarrollador Java / Open Source
TUMI Solutions SAC
Tel: +51.13481104
Cel: +51.197366260
MSN : mlindo(at)tumisolutions(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Relyea, Mike | 2005-10-07 11:52:39 | Re: MS Access / Postgres ODBC / Outer joins |
Previous Message | CN | 2005-10-07 11:29:27 | Re: pg_restore --disable-triggers does not stop triggers |