Thread: Deleting Objects...

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/

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.