Re: getObject() returns integer instead of LargeObject

On Fri, Jul 22, 2005 at 01:41:19PM -0500, Kris Jurka wrote:
>
>
> On Fri, 22 Jul 2005, Marc Herbert wrote:
>
> >  Is there some good reason for getObject(<some oid column>) to return the
> > bare oid integer instead of the actual LargeObject handle ?
>
> This makes the assumption that the only use of oids is for large objects.
> What if someone wrote SELECT oid,relname FROM pg_class?

Thanks for answering.

What would you recommend to unambiguously identify a Blob column in a
arbitrary ResultSet, using only JDBC?

For instance could you trust
Types.BLOB == rs.getMetaData.getColumnType() in every case?
Is there any other way?

Would it depend on the latest version of the driver/database?

Thanks in advance for you help!


PS: why do LOBs seem to use regular oids instead of some other less
ambiguous say, "loid" ?