Re: JDBC adaptor issue

On Sunday, June 24, 2001, at 10:32 PM, Barry Lind wrote:

> This is an interesting problem.  And I can't think a any easy 
> solution.  But given TOAST in 7.1 the existing implementation 
> doesn't make sense IMHO  My suggestion would be that the 
> get/setXXXStream methods work on TOASTed data types and 
> get/setBlob be used for Blobs.
>

That would be my preference as well.

> As far as your patch, I don't see that as a generic solution.  
> It is equally likely that a Blob could contain less than 8190 
> characters, or a varchar could contain more that 8190 
> characters in 7.1.

It's certainly not a generic solution. I was looking for a 
solution that would break fewer of the applications that rely on 
the current nonstandard behavior. I'd much prefer to simply have 
get/set...stream just implement the standard behavior. But not 
knowing the Postgres developers' preferences when it comes to 
these questions, I chose the break-fewer-existing-apps approach.

If the answer is that the Postgres developers are willing to 
tell current JDBC users to switch to the Blob/Clob methods when 
that's what they really mean, I'll remove the switch before 
submitting the patch.

-- Bruce