|
I found loid column in pg_catalog.pg_largeobject. I try to match loid with any numbers in oid column and lo column but I cannot found some that matched.
What think I do that wrong? Please advise
>>> Moises Alberto Lindo Gutarra <mlindo@xxxxxxxxx> 07-Oct-05 18:40:12 pm >>> try: delete from pg_catalog.pg_largeobject; from your database. 2005/10/6, Premsun Choltanwanich <Premsun@xxxxxxxxxxxx>: > 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@xxxxxxxxxxxxxxxxx |
