Re: [JDBC] pg_locks.transaction field type - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: [JDBC] pg_locks.transaction field type
Date
Msg-id 43040524.8060901@selectacast.net
Whole thread Raw
In response to Re: [JDBC] pg_locks.transaction field type  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: [JDBC] pg_locks.transaction field type  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-general

Oliver Jowett wrote:
> Joseph Shraibman wrote:
>
>> Is it a jdbc bug that is returning the answer as
>> org.postgresql.util.PGobject instead of some kind of Number?
>
>
> The column's type is 'xid' which the driver doesn't currently handle, so
> it gets put into the "wrap it in PGobject" bucket.

Is xid a type of number?
>
> I'm not sure what's changed between 7.4 & 8.0 -- did you also change
> JDBC driver versions?

yes
>
> Perhaps your server should convert instances of PGobject to their string
> representations before returning them across RMI.

That's what I'll do.  Are there any other classes besides
org.postgresql.util.PGobject that I have to worry about?

pgsql-general by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [JDBC] pg_locks.transaction field type
Next
From: Oliver Jowett
Date:
Subject: Re: [JDBC] pg_locks.transaction field type