Re: BLOBs etc - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: BLOBs etc
Date
Msg-id Pine.BSO.4.56.0501071500280.11678@leary.csoft.net
Whole thread Raw
In response to Re: BLOBs etc  (Thomas Hallgren <thhal@mailblocks.com>)
Responses Re: BLOBs etc  (Thomas Hallgren <thhal@mailblocks.com>)
List pgsql-jdbc

On Fri, 7 Jan 2005, Thomas Hallgren wrote:

> Kris
> > I'm not clear what your advocating in concrete terms.  A new pseudo type
> > "binary data" that could be used until it needs to convert it into a
> > concrete type?  When does this conversion have to happen?
> >
> Couldn't this be limited to the client/server protocol? There are 4
> cases that will fail today. If you attempt to:
>
> 1. stream lob data from the client for storage in a bytea.
> 2. send a bytea data "by value" for storage in a LOB.
> 3. read LOB data that is passed as a bytea.
> 4. read bytea data that is really a LOB.
>
> As you pointed out earlier, it should be possible to make the client
> handle cases #3 and #4 so what's left for the server is to deal with #1
> and #2. That doesn't sound like rocket science to me.
>

Well you've summarized the problem, but you certainly haven't given any
concrete suggestions on how this could actually be done.  I'm not sure
this even qualifies as handwaving.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: BLOBs etc
Next
From: Keith Hankin
Date:
Subject: Re: One byte integer support