pg_locks.transaction field type
| От | Joseph Shraibman |
|---|---|
| Тема | pg_locks.transaction field type |
| Дата | |
| Msg-id | de0ttl$l7g$1@news.hub.org обсуждение исходный текст |
| Ответы |
Re: [JDBC] pg_locks.transaction field type
|
| Список | pgsql-general |
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?
В списке pgsql-general по дате отправления: