Re: BLOBs etc

On Fri, 7 Jan 2005, [ISO-8859-15] Sven Köhler wrote:

> But still the postgresql server could accept the data generated by the 
> JDBC-driver's "setBinaryStream()" even for oid columns. Isn't that the 
> missing piece to make set/getBinaryStream() methods work for oid columns?

That would work, but it's not going to happen.  Setting up and using a
large object is completely different than just stashing data in a bytea
field.  Convincing the server to do simple conversions is difficult
enough, getting it to do something of this magnitude is out of the
question.

> Is it known how other JDBC drivers handle this problems?

The real problem here is that pg has two binary data types that work quite 
differently and each have significant strengths/weaknesses.  Other 
databases don't have this predicament.  If we only had one or one was 
clearly superior or they used a remotely similar API we'd be set.

Kris Jurka