(Maybe) helpful data surrounding crashes

[Erwin Brandstetter <brandstetter(at)falter(dot)at>]

Hi developers! Hi Dave!

Testing pgAdmin v.1.8.2 (Feb 5 2008), rev: 7050, on WinXP; host: pg 8.2.6 on 
Debian Etch

I have been having occasional crashes with pgAdmin 1.8.x. I still cannot pin 
down the cause, it only happens like once on a busy day. They have something 
in common: always when I click on an object in the object browser. This time, 
after clicking on a schema (the first time since I connected to this 
database, other databases of the same "server connection"-object already 
open), while retrieving schema data.

Maybe it is of relevance that I have 12 different "server connection"-objects 
in my object browser. Two of them were open before the crash.

Other programs do not normally crash on this machine.

This is the tail of my pgAdmin-Log before the crash:

-- pgAdmin log start --
(...)
2008-03-28 19:09:27 QUERY  : Set query (86.59.118.251:5432): SELECT oid,
format_type(oid, typtypmod) AS typname FROM pg_type
2008-03-28 19:09:27 QUERY  : Set query (86.59.118.251:5432): SELECT t.oid,
t.*, format_type(t.oid, null) AS alias, pg_get_userbyid(t.typowner) as
typeowner, e.typname as element, description, ct.oid AS taboid
  FROM pg_type t
  LEFT OUTER JOIN pg_type e ON e.oid=t.typelem
  LEFT OUTER JOIN pg_class ct ON ct.oid=t.typrelid AND ct.relkind <> 'c'
  LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
 WHERE t.typtype != 'd' AND t.typname NOT LIKE E'\\_%%' AND t.typnamespace =
153217::oid
   AND ct.oid IS NULL
 ORDER BY t.typname
2008-03-28 19:09:27 QUERY  : Set query (86.59.118.251:5432): SELECT c.oid,
c.xmin, c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl,
description, pg_get_viewdef(c.oid, true) AS definition
  FROM pg_class c
  LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and des.objsubid=0)
 WHERE ((c.relhasrules AND (EXISTS (
           SELECT r.rulename FROM pg_rewrite r
            WHERE ((r.ev_class = c.oid)
              AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind =
'v'::char))
   AND relnamespace = 153217::oid
 ORDER BY relname
2008-03-28 19:09:27 STATUS : Retrieving Schema details... (0.23 secs)
-- pgAdmin log end --


BTW: 1 '%' is redundant here: ... t.typname NOT LIKE E'\\_%%' ...


Regards
Erwin