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

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

I'm not sure what's changed between 7.4 & 8.0 -- did you also change
JDBC driver versions?

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

-O

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: pg_locks.transaction field type
Next
From: Joseph Shraibman
Date:
Subject: Re: [JDBC] pg_locks.transaction field type