Hi Dave! Hi developers!
Testing pgAdmin v.1.9.0-Dev (May 2 2008, rev: 7245, on WinXP Pro; hosts:
pg 8.2.7 and 8.3.1 on Debian Etch
Looking forward to the upcoming 1.8.3 release!
You may want to have a look at the following first, though ...
I have been testing the above version occasionally over the last couple
of weeks (mostly object tree, data grid, sql window, and some random
tests). Most everything looks good or better than before. I've found a
way to crash it, though.
Using the right mouse button in the data grid (table or view) sends
pgAdmin packing almost every time. Sometimes, however, it doesn't. I
could not find why.
I have tested with a variation of tables and views in various DB
clusters, big and small, various data, various selections before right
clicking. For some time I had the hypothesis it would crash every time,
once a filter was involved. But after like 20 crashes in various
settings, it would even work with a filter on a view. Shortly after
that, right mouse click in a table (an no filter) ended the session.
So, I have no conclusive explanation to offer.
I have set pgAdmin logging to "debug". The log file invariably ends in a
couple of these lines.
2008-05-30 01:39:39 QUERY : Scalar query (localhost:65433): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 25
2008-05-30 01:39:39 QUERY : Query result: text
2008-05-30 01:39:39 QUERY : Scalar query (localhost:65433): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 1114
2008-05-30 01:39:39 QUERY : Query result: timestamp without time zone
2008-05-30 01:39:39 QUERY : Scalar query (localhost:65433): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2008-05-30 01:39:40 QUERY : Query result: integer
2008-05-30 01:39:40 QUERY : Scalar query (localhost:65433): SELECT
format_type(oid,NULL) as typname FROM pg_type WHERE oid = 16
2008-05-30 01:39:40 QUERY : Query result: boolean
I can send some sample log files if that helps.
Regards
Erwin
