Re: BLOBs etc

>>on the jdbc-webpages it says, that the JDBC team may decide to change
>>getBLOBG/setBLOB to support bytea only, and that one should use the
>>PostGreSQL specific LargeObject extension to acces them.
>
> I'm not sure where it says that, but it is either out of date or just
> plain bad advice.  If you could point out where it says that I'd
> appreciate it.  I would stick withe the standard Blob interface for now.

http://www.postgresql.org/docs/7.4/static/jdbc-binary-data.html

There is says:
Note:  In a future release of the JDBC driver, the getBLOB() and
setBLOB() methods may no longer interact with Large Objects and will
instead work on the data type bytea. So it is recommended that you use
the LargeObject API if you intend to use Large Objects.


BTW: why don't getInputStream/getBLOB/... work for _both_, bytea and
oid? Shouldn't the JDBC driver be abled to determine the used datatype
and act accordingly? I'm sure you had you reasons. I'd just like to know
them.