3 messages in org.postgresql.pgsql-jdbcstreaming bytea: is it possible ?
FromSent OnAttachments
Csaba NagyJul 25, 2006 9:37 am 
Kris JurkaJul 25, 2006 11:26 am 
Csaba NagyJul 26, 2006 1:02 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:streaming bytea: is it possible ?Actions...
From:Csaba Nagy (na@ecircle-ag.com)
Date:Jul 25, 2006 9:37:10 am
List:org.postgresql.pgsql-jdbc

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.