Thread

1. Deleting Objects...

   Rolando Lora <rlddm@yahoo.com> — 2001-03-25T22:08:47Z

   Hi there...
   
   I'm not sure if this is a "bug" or not but I couldn't
   find how to deal with it.
   
   For instance if we create a table using "Object ID"
   for storing large objects:
   
   > create table picture(id serial, pic_oid oid);
   
   and then we add some data:
   
   > insert into picture 
     (pic_oid) values (lo_import('/tmp/image.jpg'));
   
   We'll insert into the table an "Object Id" pointing to
   an external file "xin...OID".
   
   But when we execute:
   
   > delete from picture;
   
   The data contained in the table gets deleted but the
   real object "xin...OID" remains untouched when (I
   Think) it should be deleted too. Is this a bug?
   
   I'm developing an application where I need to upload a
   lot of pictures but when I delete some of them I don't
   want files floating around that used to be pictures.
   
   Is there anyway I can deal with it?
   
   Thanks in advance...
   ------------------------------
   Rolando Lora
   Blackstar Co - Development
   Bolivia - South America
   ------------------------------
   
   __________________________________________________
   Do You Yahoo!?
   Get email at your own domain with Yahoo! Mail. 
   http://personal.mail.yahoo.com/
   
   

2. Re: Deleting Objects...

   Stephan Szabo <sszabo@megazone23.bigpanda.com> — 2001-03-26T03:43:16Z

   On Sun, 25 Mar 2001, Rolando Lora wrote:
   
   > Hi there...
   > 
   > I'm not sure if this is a "bug" or not but I couldn't
   > find how to deal with it.
   > 
   > For instance if we create a table using "Object ID"
   > for storing large objects:
   > 
   > > create table picture(id serial, pic_oid oid);
   > 
   > and then we add some data:
   > 
   > > insert into picture 
   >   (pic_oid) values (lo_import('/tmp/image.jpg'));
   > 
   > We'll insert into the table an "Object Id" pointing to
   > an external file "xin...OID".
   > 
   > But when we execute:
   > 
   > > delete from picture;
   > 
   > The data contained in the table gets deleted but the
   > real object "xin...OID" remains untouched when (I
   > Think) it should be deleted too. Is this a bug?
   > 
   > I'm developing an application where I need to upload a
   > lot of pictures but when I delete some of them I don't
   > want files floating around that used to be pictures.
   > 
   > Is there anyway I can deal with it?
   
   Generally speaking I think right now you need to put
   a trigger on the table to remove the large objects when
   the row is deleted.