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