RE: [PEAR-DEV] MDB - Delete LOB

> From: Alexey Borzov [mailto:borz_off@cs.msu.su] > Sent: Sunday, June 08, 2003 5:03 PM > > 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 thx, will look into it regards, Lukas