Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0G9Cl071163 for ; Tue, 16 Jan 2001 04:12:47 -0500 (EST) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by mail.retep.org.uk (8.11.1/8.11.1) id f0G9CkI71158; Tue, 16 Jan 2001 04:12:46 -0500 (EST) (envelope-from peter@retep.org.uk) X-Authentication-Warning: mail.retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: xriley@encryptix.com Subject: Re: Deleting a list of external xinv/xinx files using JDBC Message-ID: <979636366.3a64108e75214@webmail.retep.org.uk> Date: Tue, 16 Jan 2001 04:12:46 -0500 (EST) From: Peter T Mount Cc: pgsql-interfaces@postgresql.org, xriley@encryptix.com References: <19016070071ED411B61300508BAC4B75915D6D@exch1etix.encryptix.com> In-Reply-To: <19016070071ED411B61300508BAC4B75915D6D@exch1etix.encryptix.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200101/154 X-Sequence-Number: 768 Quoting xriley@encryptix.com: > 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? Yes this is by design (in the backend) as there is no real link between your table and the blob. If you look under /contrib you will find ways of fixing this using triggers that watch your table and when a row containing a blob is deleted or the blob amended then the old blob is deleted in the background. Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/