Re: getObject() returns integer instead of LargeObject - Mailing list pgsql-jdbc

From Marc Herbert
Subject Re: getObject() returns integer instead of LargeObject
Date
Msg-id 20050726102009.GB17905@emicnetworks.com
Whole thread Raw
In response to Re: getObject() returns integer instead of LargeObject  (Kris Jurka <books@ejurka.com>)
Responses Re: getObject() returns integer instead of LargeObject  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
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" ?


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Java's set of timezone names
Next
From: Dave Cramer
Date:
Subject: Re: work in progress: timestamp patch