Re: pgadmin from 9.0RC1 in 8.2.4 status cannot cast type xid to text error

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(at)iol(dot)ie