MDB - Delete LOB

From: Date: Sun, 08 Jun 2003 07:48:03 +0000
Subject: MDB - Delete LOB
Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-17160@lists.php.net to get a copy of this message
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... Let's suppose to have table like this Table file_system item_id int item_oid oid item_name text 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?) Thank's -- PJ -- PJ

« previous php.pear.dev (#17160) next »