pgAdmin III 1.4 Beta-3 crashes when opening a trigger's
property-dialog from either the popup menu or the shortcut button or
the Edit menu.
Client: Windows XP Pro, SP2. pgAdmin III language: English
Server: Debian linux postgreSQL 8.0
pgAdmin III v1.22 opens the same triggers fine.
debug-log says:
### QUOTE BEGINS
2005-10-25 17:16:10 INFO : Displaying properties for Table tg_mytable_ar5iu
2005-10-25 17:16:10 STATUS : Retrieving Table details...
2005-10-25 17:16:10 QUERY : Set query (myserver:5432): SELECT pr.oid,
pr.*, TYP.typname, TYPNS.nspname AS typnsp, lanname, proargnames,
pg_get_userbyid(proowner) as funcowner, description
FROM pg_proc pr
JOIN pg_type TYP ON TYP.oid=prorettype
JOIN pg_namespace TYPNS ON TYPNS.oid=TYP.typnamespace
JOIN pg_language LNG ON LNG.oid=prolang
LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
WHERE pr.oid=50783866::oid
ORDER BY proname
2005-10-25 17:16:10 INFO : Creating pgSetBase object
2005-10-25 17:16:10 QUERY : Set query (myserver:5432): SELECT t.oid,
t.typname, n.nspname FROM pg_type t, pg_namespace n WHERE
t.typnamespace = n.oid
2005-10-25 17:16:10 INFO : Creating pgSetBase object
2005-10-25 17:16:10 INFO : Creating a pgFunction object
2005-10-25 17:16:10 INFO : Destroying pgSetBase object
2005-10-25 17:16:10 INFO : Destroying pgSetBase object
2005-10-25 17:16:10 STATUS : Retrieving Table details... (0.02 secs)
2005-10-25 17:16:33 INFO : Creating a ctlSQLBox
2005-10-25 17:16:33 QUERY : Set query (myserver:5432): SELECT groname
FROM pg_group ORDER BY groname
2005-10-25 17:16:33 INFO : Creating pgSetBase object
2005-10-25 17:16:33 INFO : Destroying pgSetBase object
2005-10-25 17:16:33 QUERY : Set query (myserver:5432): SELECT usename
FROM pg_user ORDER BY usename
2005-10-25 17:16:33 INFO : Creating pgSetBase object
2005-10-25 17:16:33 QUERY : Set query (myserver:5432): SELECT spcname
FROM pg_tablespace WHERE spcname <> 'global' ORDER BY spcname
2005-10-25 17:16:33 INFO : Creating pgSetBase object
### QUOTE ENDS
(This is the end of the log file.)
Regards,
dueyduey
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
