MDB - Delete LOB
| From: | Davide PJ Caironi | 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