Обсуждение: pgadmin from 9.0RC1 in 8.2.4 status cannot cast type xid to text error

I ran PgAdmin from 9.0RC1 in windows and selected

Tools/Server status for 8.2.4 server

After that messagebox with error

---------------------------
pgAdmin III
---------------------------
An error has occurred:

ERROR:  cannot cast type xid to text
LINE 1: SELECT transaction::text, gid, prepared, owner, database FRO...
                            ^
---------------------------
OK
---------------------------

occurs after every few seconds
After some time there are hundreds of messageboxes in screen.
Message boxes continue to apper even if status window is closed.

How to fix ?

Andrus.

On 04/10/2010 17:01, Andrus wrote:
> I ran PgAdmin from 9.0RC1 in windows and selected
> Tools/Server status for 8.2.4 server
>
> After that messagebox with error
> ---------------------------
> pgAdmin III
> ---------------------------
> An error has occurred:
>
> ERROR: cannot cast type xid to text
> LINE 1: SELECT transaction::text, gid, prepared, owner, database FRO...
> ^
> ---------------------------
> OK ---------------------------
>
> occurs after every few seconds
> After some time there are hundreds of messageboxes in screen.
> Message boxes continue to apper even if status window is closed.
>
> How to fix ?


I can't help with the cast error, but you can reduce the frequency with
which pgAdmin reloads the server status - in the toolbar at the top,
there's a drop-down combo with various refresh rates. This will at least
stop all those error dialogs popping up, and give you a chance to fix
the real problem. :-)

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

2010/10/4 Andrus <kobruleht2@hot.ee>:
> I ran PgAdmin from 9.0RC1 in windows and selected
> Tools/Server status for 8.2.4 server
>
> After that messagebox with error
> ---------------------------
> pgAdmin III
> ---------------------------
> An error has occurred:
>
> ERROR:  cannot cast type xid to text
> LINE 1: SELECT transaction::text, gid, prepared, owner, database FRO...
>                           ^
> ---------------------------
> OK   ---------------------------
>
> occurs after every few seconds
> After some time there are hundreds of messageboxes in screen.
> Message boxes continue to apper even if status window is closed.
>
> How to fix ?

Run pgAdmin 1.12.1, not a release candidate.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company