[pgadmin-support] update postgreSQL 9.0

2013-01-03 Thread Annette Ketils
HiMy Secunia PSI informs, that I should update the postgreSQL 9.0. I don't know, what kind of program it is, and I have to update it manually. Can you help me? Annette Ketils

[pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh

2013-01-03 Thread Robert Klaus
This message was posted in the pgsql-general and novice lists, and I was cirected here . . . sorry for those of you receiving multiple posts. We have 36,000+ rows returned by " SELECT oid, format_type(oid, typtypmod) AS typname FROM pg_type". My manager says this is only a small numbe

[pgadmin-support] Server Status window issue

2013-01-03 Thread Campbell, Lance
PostgreSQL 9.2.2 pgAdmin 1.16.1 pgAdmin > Tools > Server Status When viewing the Server Status window I notice that my queries look like this: SELECT * FROM tablex WHERE id=$1 How can I display the full query without the $1? Example of what I would like to see: SELECT * FROM tablex where id=75