Thread: 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.
Re: pgadmin from 9.0RC1 in 8.2.4 status cannot cast type xid to text error
From
Raymond O'Donnell
Date:
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