Re: MDB - Delete LOB

Hi! Davide PJ Caironi wrote:

Hi all, I'm working on a project involving Large Object inside a DB. I started using postgresql and PEAR:MDB as db abstraction layer (by the way, very good package!), because PEAR:DB (that I used in the past) doesn't support LOB. The LOB handling works well, at least the insert in db and retrive from db. I'm looking for a simlpe way to delete lob from db...

Maybe you can get rid of LOBs and just use the bytea fields? They are processed just like normal fields, without convoluted API, and only require some additional 'quoting' (dunno whether this quoting is directly supported by either DB or MDB). Read here: http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=datatype-binary.html