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
