Обсуждение: streaming bytea: is it possible ?

Hi all,

I wonder if it is possible to stream bytea fields without reading them
completely in memory ?

The reason I want that is because I want to use slony1 to replicate some
tables containing BLOBs, and slony can't handle BLOBs. So I would like
to convert the BLOBs to bytea (which can be handled properly by slony1),
but I can't afford to load the complete BLOBs in memory, I only need to
stream them. Now I wonder if the postgres JDBC implementation/postgres
server is capable of doing that, or any of them needs to have the
complete bytea in memory at one point...

Of course I could check the source but if any of you knows it offhand I
would appreciate an answer.

Thanks,
Csaba.

On Tue, 25 Jul 2006, Csaba Nagy wrote:

> I wonder if it is possible to stream bytea fields without reading them
> completely in memory ?

http://archives.postgresql.org/pgsql-jdbc/2006-03/msg00079.php

Kris Jurka

Kris,

On Tue, 2006-07-25 at 20:27, Kris Jurka wrote:
> On Tue, 25 Jul 2006, Csaba Nagy wrote:
>
> > I wonder if it is possible to stream bytea fields without reading them
> > completely in memory ?
>
> http://archives.postgresql.org/pgsql-jdbc/2006-03/msg00079.php

Thanks for the link, it answers exactly my situation... unfortunately in
a negative sense :-(

Cheers,
Csaba.