Skip site navigation (1) Skip section navigation (2)

pg_locks.transaction field type

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: pg_locks.transaction field type
Date: 2005-08-18 03:05:25
Message-ID: de0ttl$l7g$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
I have a method in my rmi server that takes a query and returns an 
Object[][].  I had this query:

SELECT (select relname from pg_catalog.pg_class where relfilenode = 
relation) as relname, * FROM pg_locks;

After upgrading from 7.4 to 8.0 I was getting this problem:
WARNING: Servlet.service() for servlet jsp threw exception
java.rmi.UnmarshalException: error unmarshalling return; nested 
exception is:
         java.lang.ClassNotFoundException: org.postgresql.util.PGobject 
(no security manager: RMI class loader disabled)


The problem seems to be the "transaction" field.  It looks like a number 
type, but I can't really tell because "\d pg_catalog" doesn't work in psql.

So what's the difference between 7.4.7 and 8.0.3?  Is it that 7.4.7 
never returned anything in the transaction field?  Is it a jdbc bug that 
is returning the answer as org.postgresql.util.PGobject instead of some 
kind of Number?

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-08-18 03:27:33
Subject: Re: [JDBC] pg_locks.transaction field type
Previous:From: Oliver JowettDate: 2005-08-17 23:49:39
Subject: Re: java.sql.SQLException: ERROR: canceling query due to user

pgsql-general by date

Next:From: Oliver JowettDate: 2005-08-18 03:27:33
Subject: Re: [JDBC] pg_locks.transaction field type
Previous:From: Premsun CholtanwanichDate: 2005-08-18 02:56:49
Subject: How to secure PostgreSQL Data for distribute?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group