Deleting a list of external xinv/xinx files using JDBC

From: xriley(at)encryptix(dot)com
To: pgsql-interfaces(at)postgresql(dot)org
Cc: xriley(at)encryptix(dot)com
Subject: Deleting a list of external xinv/xinx files using JDBC
Date: 2001-01-16 02:51:16
Message-ID: 19016070071ED411B61300508BAC4B75915D6D@exch1etix.encryptix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I'm using the JDBC setBytes to insert a list of large object blobs.
The side-effect of this is two external files (xinvOID and xinxOID)
for every blob inserted.

If I use a JDBC delete sql statement to delete the records
containing the blobs, the external xin* files are not deleted.

Is this by design? If so, is there a work around for deleting
a LIST of records AND the associated external blob file?


Foe example:
CREATE TABLE "some_blobs" (
"blob_id" int4 PRIMARY KEY,
"the_blob" oid NOT NULL
);

JDBC insert statement for adding blob records:
insert into some_blobs (blob_id, the_blob) values (?,?)

JDBC delete statement for removing all blob records:
delete from some_blobs

Thanks
Xavier

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas Lockhart 2001-01-16 05:12:29 Re: outer join in PostgreSql
Previous Message Peter Eisentraut 2001-01-15 22:21:27 Re: [INTERFACES] outer join in PostgreSql