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/
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
