Re: RE: Re: deleting large objects from jdbc - Mailing list pgsql-jdbc

From Rene Pijlman
Subject Re: RE: Re: deleting large objects from jdbc
Date
Msg-id h6g4nt08phj10gs2o3sletc8s8ajcchcmc@4ax.com
Whole thread Raw
In response to RE: Re: deleting large objects from jdbc  (heatherm@famoice.com)
List pgsql-jdbc
On Thu, 9 Aug 2001 14:58:13 +1000, Heather wrote:
[delete Lob when no longer referenced]
>Shouldn't the JDBC driver fix up things like that though?

Its not an interface issue. You'll see exactly the same
behaviour using the interfaces for C/C++, Perl, Python etc.

This is not something an interface can easily fix. The driver on
the client side does not know if there are any rows referencing
the Lob.

If this needs to be changed, it would have to be changed on the
backend. Barry suggested last week to eventually change the
Blob-implementation to the toast model. That would make a Blob
part of a row and the delete kludge would no longer be needed.

Regards,
René Pijlman

pgsql-jdbc by date:

Previous
From: heatherm@famoice.com
Date:
Subject: RE: Re: deleting large objects from jdbc
Next
From: "RaviShankar K"
Date:
Subject: How to deal with "oid" field when it contains NULL ?