I use XP Pro latest hot fix.
Azttached the logfile ... hope this helps ...
Regards,
Claus
2003-09-19 08:44:08 INFO :
##############################################################
2003-09-19 08:44:08 INFO : # pgAdmin III Version 0.9.2 BETA 2 Startup
2003-09-19 08:44:08 INFO :
##############################################################
2003-09-19 08:44:08 INFO : Compiled with OpenSSL 0.9.7b 10 Apr 2003
2003-09-19 08:44:08 INFO : Creating a splash screen
2003-09-19 08:44:11 INFO : Creating a ctlSQLBox
2003-09-19 08:44:11 INFO : Creating a pgCollection object
2003-09-19 08:44:11 INFO : Reloading servers...
2003-09-19 08:44:11 INFO : Creating a pgServer object
2003-09-19 08:44:11 INFO : Destroying a splash screen
2003-09-19 08:44:14 INFO : Creating an options dialogue
2003-09-19 08:44:17 INFO : Destroying an options dialogue
2003-09-19 08:44:18 STATUS : Retrieving server properties...
2003-09-19 08:44:18 INFO : Displaying properties for Server 192.168.1.14:5432
2003-09-19 08:44:18 INFO : Displaying properties for server 192.168.1.14:5432
2003-09-19 08:44:18 STATUS : Retrieving server properties... (0.00 secs)
2003-09-19 08:44:18 INFO : Attempting to create a connection object...
2003-09-19 08:44:18 INFO : Creating a connect dialogue
2003-09-19 08:44:20 INFO : Destroying a connect dialogue
2003-09-19 08:44:20 STATUS : Connecting to database without password...
2003-09-19 08:44:20 INFO : Creating pgConn object
2003-09-19 08:44:20 INFO : Server name: 192.168.1.14 (resolved to: 192.168.1.14)
2003-09-19 08:44:20 INFO : Opening connection with connection string:
hostaddr=192.168.1.14 dbname=template1 user=postgres port=5432
2003-09-19 08:44:20 INFO : Setting client_encoding to 'UNICODE'
2003-09-19 08:44:20 QUERY : Scalar query (192.168.1.14:5432): SELECT datlastsysoid
FROM pg_database LIMIT 1;
2003-09-19 08:44:20 QUERY : Query result: 16974
2003-09-19 08:44:20 STATUS : Connecting to database without password... (0.31 secs)
2003-09-19 08:44:20 QUERY : Scalar query (192.168.1.14:5432): SELECT version();
2003-09-19 08:44:20 QUERY : Query result: PostgreSQL 7.3.4 on i686-pc-linux-gnu,
compiled by GCC 2.95.3
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT usecreatedb,
usesuper from pg_user where usename=current_user
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 STATUS : Restoring previous environment...
2003-09-19 08:44:20 INFO : pgServer object initialised as required.
2003-09-19 08:44:20 INFO : Adding child object to server 192.168.1.14:5432
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT db.oid, datname,
datpath, datallowconn, datconfig, datacl, pg_encoding_to_char(encoding) AS
serverencoding, pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid,
'CREATE') as cancreate
FROM pg_database db
ORDER BY datname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Destroying a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Destroying a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Creating a pgDatabase object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT * from pg_group
ORDER BY groname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Scalar query (192.168.1.14:5432): SELECT
has_table_privilege('pg_shadow', 'SELECT')
2003-09-19 08:44:20 QUERY : Query result: t
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT * FROM pg_shadow
ORDER BY usename
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Creating a pgUser object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Displaying properties for Databases Databases
2003-09-19 08:44:20 INFO : Displaying properties for Database etad_test
2003-09-19 08:44:20 INFO : Creating pgConn object
2003-09-19 08:44:20 INFO : Server name: 192.168.1.14 (resolved to: 192.168.1.14)
2003-09-19 08:44:20 INFO : Opening connection with connection string:
hostaddr=192.168.1.14 dbname=etad_test user=postgres port=5432
2003-09-19 08:44:20 INFO : Setting client_encoding to 'UNICODE'
2003-09-19 08:44:20 QUERY : Scalar query (192.168.1.14:5432): SELECT datlastsysoid
FROM pg_database LIMIT 1;
2003-09-19 08:44:20 QUERY : Query result: 16974
2003-09-19 08:44:20 QUERY : Scalar query (192.168.1.14:5432): SELECT description FROM
pg_description WHERE objoid=5051907::oid
2003-09-19 08:44:20 INFO : Query returned no tuples
2003-09-19 08:44:20 QUERY : Scalar query (192.168.1.14:5432): SELECT proname FROM
pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16
2003-09-19 08:44:20 INFO : Query returned no tuples
2003-09-19 08:44:20 INFO : Adding child object to database etad_test
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT ca.oid, ca.*,
st.typname AS srctyp, tt.typname AS trgtyp, proname, nspname
FROM pg_cast ca
JOIN pg_type st ON st.oid=castsource
JOIN pg_type tt ON tt.oid=casttarget
JOIN pg_proc pr ON pr.oid=castfunc
JOIN pg_namespace na ON na.oid=pr.pronamespace
WHERE ca.oid > 16974
ORDER BY st.typname, tt.typname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT lan.oid,
lan.lanname, lanpltrusted, lanacl, hp.proname as lanproc, vp.proname as lanval
FROM pg_language lan
JOIN pg_proc hp on hp.oid=lanplcallfoid
LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator
WHERE lanispl IS TRUE
ORDER BY lanname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT CASE WHEN
nsp.oid<16974 THEN 0 WHEN nspname LIKE 'pg\_temp\_%%' THEN 1 ELSE 2 END AS nsptyp,
nsp.nspname, nsp.oid, pg_get_userbyid(nspowner) AS namespaceowner, nspacl,
description, has_schema_privilege(nsp.oid, 'CREATE') as cancreate
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE (nsp.oid = 2200 OR nsp.oid > 16974)
AND nsp.nspname NOT LIKE 'pg\_temp\_%'
ORDER BY 1, nspname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Creating a pgSchema object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Displaying properties for Schemas Schemas
2003-09-19 08:44:20 INFO : Displaying properties for Schema public
2003-09-19 08:44:20 INFO : Adding child object to schema public
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT aggfnoid::oid,
proname AS aggname, pg_get_userbyid(proowner) AS aggowner, aggtransfn,
aggfinalfn, proargtypes[0] AS aggbasetype, CASE WHEN (ti.typlen = -1 AND ti.typelem !=
0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = ti.typelem) || '[]' ELSE
ti.typname END as inputname, aggtranstype, CASE WHEN (tt.typlen = -1 AND tt.typelem !=
0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = tt.typelem) || '[]' ELSE
tt.typname END as transname, prorettype AS aggfinaltype, CASE WHEN (tf.typlen = -1 AND
tf.typelem != 0) THEN (SELECT at.typname FROM pg_type at WHERE at.oid = tf.typelem) ||
'[]' ELSE tf.typname END as finalname, agginitval, description
FROM pg_aggregate ag
JOIN pg_proc pr ON pr.oid = ag.aggfnoid
JOIN pg_type ti on ti.oid=proargtypes[0]
JOIN pg_type tt on tt.oid=aggtranstype
JOIN pg_type tf on tf.oid=prorettype
LEFT OUTER JOIN pg_description des ON des.objoid=aggfnoid::oid
WHERE pronamespace = 2200::oid
ORDER BY aggname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT co.oid, co.*,
pg_encoding_to_char(conforencoding) as forencoding, pg_get_userbyid(conowner) as
owner,pg_encoding_to_char(contoencoding) as toencoding, proname, nspname
FROM pg_conversion co
JOIN pg_proc pr ON pr.oid=conproc
JOIN pg_namespace na ON na.oid=pr.pronamespace
WHERE connamespace = 2200::oid
ORDER BY conname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT d.oid, d.typname as
domname, d.typbasetype, b.typname as basetype, pg_get_userbyid(d.typowner) as
domainowner,
d.typlen, d.typtypmod, d.typnotnull, d.typdefault, d.typndims, d.typdelim,
description
FROM pg_type d
JOIN pg_type b ON b.oid = CASE WHEN d.typndims>0 then d.typelem ELSE d.typbasetype
END
LEFT OUTER JOIN pg_description des ON des.objoid=d.oid
WHERE d.typtype = 'd' AND d.typnamespace = 2200::oid
ORDER BY d.typname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT pr.oid, pr.*,
TYP.typname, lanname, pg_get_userbyid(proowner) as funcowner, description
FROM pg_proc pr
JOIN pg_type TYP ON TYP.oid=prorettype
JOIN pg_language LNG ON LNG.oid=prolang
LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
WHERE proisagg = FALSE AND pronamespace = 2200::oid
AND typname <> 'trigger'
ORDER BY proname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT oid, typname FROM
pg_type
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT pr.oid, pr.*,
TYP.typname, lanname, pg_get_userbyid(proowner) as funcowner, description
FROM pg_proc pr
JOIN pg_type TYP ON TYP.oid=prorettype
JOIN pg_language LNG ON LNG.oid=prolang
LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
WHERE proisagg = FALSE AND pronamespace = 2200::oid
AND typname = 'trigger'
ORDER BY proname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT oid, typname FROM
pg_type
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT op.oid, op.oprname,
pg_get_userbyid(op.oprowner) as opowner, op.oprkind, op.oprcanhash,
op.oprleft, op.oprright, lt.typname as lefttype, rt.typname as righttype,
et.typname as resulttype,
co.oprname as compop, ne.oprname as negop, lso.oprname as leftsortop,
rso.oprname as rightsortop,
lco.oprname as lscmpop, gco.oprname as gtcmpop,
op.oprcode as operproc, op.oprjoin as joinproc, op.oprrest as restrproc,
description
FROM pg_operator op
LEFT OUTER JOIN pg_type lt ON lt.oid=op.oprleft
LEFT OUTER JOIN pg_type rt ON rt.oid=op.oprright
JOIN pg_type et on et.oid=op.oprresult
LEFT OUTER JOIN pg_operator co ON co.oid=op.oprcom
LEFT OUTER JOIN pg_operator ne ON ne.oid=op.oprnegate
LEFT OUTER JOIN pg_operator lso ON lso.oid=op.oprlsortop
LEFT OUTER JOIN pg_operator rso ON rso.oid=op.oprrsortop
LEFT OUTER JOIN pg_operator lco ON lco.oid=op.oprltcmpop
LEFT OUTER JOIN pg_operator gco ON gco.oid=op.oprgtcmpop
LEFT OUTER JOIN pg_descripti
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT op.oid, op.*,
pg_get_userbyid(op.opcowner) as opowner, it.typname as intypename, dt.typname as
keytypename, amname
FROM pg_opclass op
JOIN pg_am am ON am.oid=opcamid
JOIN pg_type it ON it.oid=opcintype
LEFT OUTER JOIN pg_type dt ON dt.oid=opckeytype
WHERE opcnamespace = 2200::oid
ORDER BY opcname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT cl.oid, relname,
pg_get_userbyid(relowner) AS seqowner, relacl, description
FROM pg_class cl
LEFT OUTER JOIN pg_description des ON des.objoid=cl.oid
WHERE relkind = 'S' AND relnamespace = 2200::oid
ORDER BY relname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT rel.oid, relname,
pg_get_userbyid(relowner) AS relowner, relacl, relhasoids, relhassubclass, reltuples,
description, conname, conkey
FROM pg_class rel
LEFT OUTER JOIN pg_description des ON des.objoid=rel.oid AND des.objsubid=0
LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND c.contype='p'
WHERE ((relkind = 'r') OR (relkind = 's')) AND relnamespace = 2200::oid
ORDER BY relname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Creating a pgTable object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT t.oid, t.*,
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 '\\_%%' AND t.typnamespace = 2200::oid
AND ct.oid IS NULL
ORDER BY t.typname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Creating a pgCollection object
2003-09-19 08:44:20 QUERY : Set query (192.168.1.14:5432): SELECT c.oid, c.relname,
pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description, pg_get_viewdef(c.oid)
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 = 2200::oid
ORDER BY relname
2003-09-19 08:44:20 INFO : Creating pgSet object
2003-09-19 08:44:20 INFO : Destroying pgSet object
2003-09-19 08:44:20 INFO : Displaying properties for schema public
2003-09-19 08:44:20 INFO : Displaying properties for Schema public
2003-09-19 08:44:20 INFO : Displaying properties for schema public
2003-09-19 08:44:20 STATUS : Restoring previous environment... (0.47 secs)
2003-09-19 08:44:22 INFO : Displaying properties for Tables Tables
2003-09-19 08:44:22 STATUS : Retrieving Tables details...
2003-09-19 08:44:22 INFO : Displaying statistics for tables on public
2003-09-19 08:44:22 QUERY : Set query (192.168.1.14:5432): SELECT relname, n_tup_ins,
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname
2003-09-19 08:44:22 INFO : Creating pgSet object
2003-09-19 08:44:22 INFO : Destroying pgSet object
2003-09-19 08:44:22 STATUS : Retrieving Tables details... (0.02 secs)
2003-09-19 08:44:26 INFO : Displaying properties for Table log
2003-09-19 08:44:26 STATUS : Retrieving Table details...
2003-09-19 08:44:26 INFO : Adding child object to table log
2003-09-19 08:44:26 INFO : Creating a pgCollection object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT att.*, def.*, CASE
when attndims > 0 THEN 1 ELSE 0 END AS isarray, ty.typname, tn.nspname as typnspname,
et.typname as elemtypname, relname, na.nspname, description
FROM pg_attribute att
JOIN pg_type ty ON ty.oid=atttypid
JOIN pg_namespace tn ON tn.oid=ty.typnamespace
JOIN pg_class cl ON cl.oid=attrelid
JOIN pg_namespace na ON na.oid=cl.relnamespace
LEFT OUTER JOIN pg_type et ON et.oid=ty.typelem
LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum
LEFT OUTER JOIN pg_description des ON des.objoid=attrelid AND des.objsubid=attnum
WHERE attrelid = 6475655::oid
AND attnum > 0
AND attisdropped IS FALSE
ORDER BY attnum
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Creating a pgColumn object
2003-09-19 08:44:26 INFO : Creating a pgColumn object
2003-09-19 08:44:26 INFO : Creating a pgColumn object
2003-09-19 08:44:26 INFO : Creating a pgColumn object
2003-09-19 08:44:26 INFO : Creating a pgColumn object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 INFO : Creating a pgCollection object
2003-09-19 08:44:26 INFO : Creating a pgConstraint object
2003-09-19 08:44:26 QUERY : Scalar query (192.168.1.14:5432): SELECT version();
2003-09-19 08:44:26 QUERY : Query result: PostgreSQL 7.3.4 on i686-pc-linux-gnu,
compiled by GCC 2.95.3
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT cls.oid,
cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary,
n.nspname,
proname, pn.nspname as pronspname, proargtypes, tab.relname as tabname,
indclass, description,
pg_get_expr(indpred, indrelid) as indconstraint, contype, condeferrable,
condeferred, amname
FROM pg_index idx
JOIN pg_class cls ON cls.oid=indexrelid
JOIN pg_class tab ON tab.oid=indrelid
LEFT OUTER JOIN pg_proc pr ON pr.oid=indproc
LEFT OUTER JOIN pg_namespace pn ON pn.oid=pr.pronamespace
JOIN pg_namespace n ON n.oid=tab.relnamespace
JOIN pg_am am ON am.oid=cls.relam
LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
LEFT OUTER JOIN pg_constraint con ON con.conrelid=indrelid AND conname=cls.relname
WHERE indrelid = 6475655::oid AND contype='p'
ORDER BY cls.relname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Creating a pgPrimary Key object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT ct.oid, conname,
condeferrable, condeferred, confupdtype, confdeltype, confmatchtype, conkey, confkey,
confrelid, nl.nspname as fknsp, cl.relname as fktab, nr.nspname as refnsp, cr.relname
as reftab, description
FROM pg_constraint ct
JOIN pg_class cl ON cl.oid=conrelid
JOIN pg_namespace nl ON nl.oid=cl.relnamespace
JOIN pg_class cr ON cr.oid=confrelid
JOIN pg_namespace nr ON nr.oid=cr.relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=ct.oid
WHERE contype='f' AND conrelid = 6475655::oid
ORDER BY conname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT cls.oid,
cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary,
n.nspname,
proname, pn.nspname as pronspname, proargtypes, tab.relname as tabname,
indclass, description,
pg_get_expr(indpred, indrelid) as indconstraint, contype, condeferrable,
condeferred, amname
FROM pg_index idx
JOIN pg_class cls ON cls.oid=indexrelid
JOIN pg_class tab ON tab.oid=indrelid
LEFT OUTER JOIN pg_proc pr ON pr.oid=indproc
LEFT OUTER JOIN pg_namespace pn ON pn.oid=pr.pronamespace
JOIN pg_namespace n ON n.oid=tab.relnamespace
JOIN pg_am am ON am.oid=cls.relam
LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
LEFT OUTER JOIN pg_constraint con ON con.conrelid=indrelid AND conname=cls.relname
WHERE indrelid = 6475655::oid AND contype='u'
ORDER BY cls.relname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT c.oid, conname,
condeferrable, condeferred, relname, nspname,
pg_get_expr(conbin, conrelid) as consrc
FROM pg_constraint c
JOIN pg_class cl ON cl.oid=conrelid
JOIN pg_namespace nl ON nl.oid=relnamespace
WHERE contype = 'c' AND conrelid = 6475655::oid
ORDER BY conname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 INFO : Creating a pgCollection object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT cls.oid,
cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary,
n.nspname,
proname, pn.nspname as pronspname, proargtypes, tab.relname as tabname,
indclass, description,
pg_get_expr(indpred, indrelid) as indconstraint, contype, condeferrable,
condeferred, amname
FROM pg_index idx
JOIN pg_class cls ON cls.oid=indexrelid
JOIN pg_class tab ON tab.oid=indrelid
LEFT OUTER JOIN pg_proc pr ON pr.oid=indproc
LEFT OUTER JOIN pg_namespace pn ON pn.oid=pr.pronamespace
JOIN pg_namespace n ON n.oid=tab.relnamespace
JOIN pg_am am ON am.oid=cls.relam
LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
LEFT OUTER JOIN pg_constraint con ON con.conrelid=indrelid AND conname=cls.relname
WHERE indrelid = 6475655::oid
AND conname IS NULL
ORDER BY cls.relname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 INFO : Creating a pgCollection object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT rw.oid,
rw.ev_class, rulename, relname, nspname, description, is_instead, ev_type, ev_action,
ev_qual,
pg_get_ruledef(rw.oid) AS definition
FROM pg_rewrite rw
JOIN pg_class cl ON cl.oid=rw.ev_class
JOIN pg_namespace nsp ON nsp.oid=cl.relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=rw.oid
WHERE ev_class = 6475655
ORDER BY rulename
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 INFO : Creating a pgCollection object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT t.oid, t.*,
relname, nspname, des.description
FROM pg_trigger t
JOIN pg_class cl ON cl.oid=tgrelid
JOIN pg_namespace na ON na.oid=relnamespace
LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
WHERE NOT tgisconstraint AND tgrelid = 6475655::oid
ORDER BY tgname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT attname
FROM pg_attribute
WHERE attrelid=6475655::oid AND attnum IN (1)
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT attname
FROM pg_attribute
WHERE attrelid=6475655::oid AND attnum IN (2)
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT count(*) AS rows
FROM public.log
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT c.relname , nspname
FROM pg_inherits i
JOIN pg_class c ON c.oid = i.inhparent
JOIN pg_namespace n ON n.oid=c.relnamespace
WHERE i.inhrelid = 6475655::oid
ORDER BY inhseqno
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 INFO : Displaying statistics for Table on public
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT seq_scan AS
"Sequential Scans", seq_tup_read AS "Sequential Tuples Read", idx_scan AS "Index
Scans", idx_tup_fetch AS "Index Tuples Fetched", n_tup_ins AS "Tuples Inserted",
n_tup_upd AS "Tuples Updated", n_tup_del AS "Tuples Deleted",heap_blks_read AS "Heap
Blocks Read", heap_blks_hit AS "Heap Blocks Hit", idx_blks_read AS "Index Blocks
Read", idx_blks_hit AS "Index Blocks Hit", toast_blks_read AS "Toast Blocks Read",
toast_blks_hit AS "Toast Blocks Hit", tidx_blks_read AS "Toast Index Blocks Read",
tidx_blks_hit AS "Toast Index Blocks Hit"
FROM pg_stat_all_tables stat, pg_statio_all_tables statio
WHERE stat.relid = statio.relid
AND stat.relid = 6475655::oid
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 STATUS : Retrieving Table details... (0.09 secs)
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT indkey FROM pg_index
WHERE indrelid=6475655::oid
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT conkey
FROM pg_constraint ct
JOIN pg_class cl on cl.oid=confrelid
WHERE contype='f' AND conrelid = 6475655::oid
ORDER BY conname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT indkey FROM pg_index
WHERE indrelid=6475655::oid
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT conkey
FROM pg_constraint ct
JOIN pg_class cl on cl.oid=confrelid
WHERE contype='f' AND conrelid = 6475655::oid
ORDER BY conname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT indkey FROM pg_index
WHERE indrelid=6475655::oid
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT conkey
FROM pg_constraint ct
JOIN pg_class cl on cl.oid=confrelid
WHERE contype='f' AND conrelid = 6475655::oid
ORDER BY conname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT indkey FROM pg_index
WHERE indrelid=6475655::oid
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT conkey
FROM pg_constraint ct
JOIN pg_class cl on cl.oid=confrelid
WHERE contype='f' AND conrelid = 6475655::oid
ORDER BY conname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT indkey FROM pg_index
WHERE indrelid=6475655::oid
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT conkey
FROM pg_constraint ct
JOIN pg_class cl on cl.oid=confrelid
WHERE contype='f' AND conrelid = 6475655::oid
ORDER BY conname
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT attname as
conattname
FROM pg_attribute
WHERE attrelid=6475655::oid AND attnum=1
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT attname as
conattname
FROM pg_attribute
WHERE attrelid=6475655::oid AND attnum=2
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT opcname FROM
pg_opclass WHERE oid=2003
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:26 QUERY : Set query (192.168.1.14:5432): SELECT opcname FROM
pg_opclass WHERE oid=1998
2003-09-19 08:44:26 INFO : Creating pgSet object
2003-09-19 08:44:26 INFO : Destroying pgSet object
2003-09-19 08:44:28 INFO : Creating pgConn object
2003-09-19 08:44:28 INFO : Server name: 192.168.1.14 (resolved to: 192.168.1.14)
2003-09-19 08:44:28 INFO : Opening connection with connection string:
hostaddr=192.168.1.14 dbname=etad_test user=postgres port=5432
2003-09-19 08:44:28 INFO : Setting client_encoding to 'UNICODE'
2003-09-19 08:44:28 QUERY : Scalar query (192.168.1.14:5432): SELECT datlastsysoid
FROM pg_database LIMIT 1;
2003-09-19 08:44:28 QUERY : Query result: 16974
2003-09-19 08:44:28 INFO : Creating EditGrid
2003-09-19 08:44:28 INFO : Running query SELECT Oid, * FROM public.log ORDER BY
"userid, log_time"
2003-09-19 08:44:28 QUERY : Thread Query SELECT Oid, * FROM public.log ORDER BY
"userid, log_time"
2003-09-19 08:44:31 INFO : Destroying SQL EditGrid
2003-09-19 08:44:31 INFO : Destroying pgConn object
2003-09-19 08:44:32 INFO : Storing listed servers for later...
2003-09-19 08:44:32 INFO : Stored 1 servers.
2003-09-19 08:44:32 INFO : Destroying a pgDatabase object
2003-09-19 08:44:32 INFO : Destroying a pgDatabase object
2003-09-19 08:44:32 INFO : Destroying a pgDatabase object
2003-09-19 08:44:32 INFO : Destroying a pgDatabase object
2003-09-19 08:44:32 INFO : Destroying a pgDatabase object
2003-09-19 08:44:32 INFO : Destroying a pgDatabase object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgColumn object
2003-09-19 08:44:32 INFO : Destroying a pgColumn object
2003-09-19 08:44:32 INFO : Destroying a pgColumn object
2003-09-19 08:44:32 INFO : Destroying a pgColumn object
2003-09-19 08:44:32 INFO : Destroying a pgColumn object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgPrimary Key object
2003-09-19 08:44:32 INFO : Destroying a pgConstraint object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgTable object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:32 INFO : Destroying a pgSchema object
2003-09-19 08:44:32 INFO : Destroying a pgCollection object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying pgConn object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgDatabase object
2003-09-19 08:44:33 INFO : Destroying a pgCollection object
2003-09-19 08:44:33 INFO : Destroying a pgCollection object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgUser object
2003-09-19 08:44:33 INFO : Destroying a pgCollection object
2003-09-19 08:44:33 INFO : Destroying pgConn object
2003-09-19 08:44:33 INFO : Destroying a pgServer object
2003-09-19 08:44:33 INFO : Destroying a pgCollection object
2003-09-19 08:44:33 INFO : Destroying a ctlSQLBox
2003-09-19 08:44:33 INFO : Destroying sysSettings object and saving settings
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
