Re: MDB - Delete LOB

"Lukas Smith" <smith@backendmedia.com> wrote in message news:000d01c32da0$d29010e0$4e00a8c0@vandal... > > From: Davide PJ Caironi [mailto:dcaironi@yahoo.com] > > Sent: Sunday, June 08, 2003 9:48 AM > > > If I simply make a query like "DELETE from file_system where item_id = > x", > > the row x disappear from the table file_system, but the large object > > (referred by oid) still remain in the database (as you can see using a > \dl > > command inside psql shell). > > So, using MDB is possible to delete also the Large Object witout using > > direcly the php command pg_lounlink($oid)? (i.e., MDB has an > "abstract" > > function for this?) > > Unfortunately this is not yet supported. > > If you can write a method that supports this in the pgsql driver please > do. > > Regards, > Lukas > OK, I'll try. Just a few question: Is this supported in another driver or direclty in another DB, like Oracle? (sorry, but I don't know well another db other than postgresql) I mean, in your opinion it's better to write a specific method or implement this feature in a "trasparent" way making MDB able to delete also the LOB when the user make a simple DELETE query? Regards PJ