Re: [SQL] How to delete Large Object from Database?

[Premsun Choltanwanich]

The lib I use is call lo_in and lo_out for manage BLOB.   I understand that lo_unlink be related with lo_import and lo_export so I don't think that it work. >>> Richard Huxton <dev@archonet.com> 07-Oct-05 14:30:05 pm >>> Premsun Choltanwanich wrote: > > 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. > So,How to delete Large Object from Database? or Is my understanding wrong? Deleting the OID does not remove the object itself - see details of lo_unlink() in Chapter 28 of the manuals. I seem to recall some other utilities in the contrib/ directory of the source distribution too. --    Richard Huxton    Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to        choose an index scan if your joining column's datatypes do not        match