Re: pgadmin III: query builder

> -----Original Message-----
> From: Marc Cuypers [mailto:mozilla(at)mgvd(dot)be]
> Sent: 16 June 2003 12:27
> To: Dave Page
> Subject: Re: [pgadmin-hackers] pgadmin III: query builder
>
>
> I installed te xrc files.
>
> Now the logging window works. I activated debug mode.
> The problem in query builder is still there. The program
> crashes when I
> selected a table (in add table) and clicked OK.
>
> Hereunder the output in the logfile:

I can repeat it sometimes, but not others - couldn't see a pattern,
though double-clicks seem to be more vulnerable on my system.

Keith, any ideas what's going on? You know the code far better than I...

Regards, Dave.

-------------START
2003-06-16 13:21:13 STATUS : Retrieving server properties...
2003-06-16 13:21:13 STATUS : Retrieving server properties... Done. (0.12

secs)
2003-06-16 13:21:15 STATUS : Connecting to database without password...
2003-06-16 13:21:15 STATUS : Connecting to database without password...
Done. (0.19 secs)
2003-06-16 13:21:15 QUERY : Scalar query (test:5432): SELECT version();
2003-06-16 13:21:15 QUERY : Query result: PostgreSQL 7.3.3 on
i686-pc-linux-gnu, compiled by GCC 2.95.4
2003-06-16 13:21:15 QUERY : Set query (test:5432): SELECT db.oid,
datname, datpath, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)

AS datowner
FROM pg_database db
ORDER BY datname
2003-06-16 13:21:15 QUERY : Scalar query (test:5432): SELECT
datlastsysoid FROM pg_database LIMIT 1;
2003-06-16 13:21:15 QUERY : Query result: 16974
2003-06-16 13:21:15 QUERY : Set query (test:5432): SELECT * from
pg_group
2003-06-16 13:21:15 QUERY : Set query (test:5432): SELECT * FROM
pg_shadow
2003-06-16 13:21:15 STATUS : Retrieving Databases details...
2003-06-16 13:21:15 STATUS : Retrieving Databases details... Done. (0.00

secs)
2003-06-16 13:21:15 STATUS : Retrieving Database details...
2003-06-16 13:21:16 QUERY : Set query (test:5432): SELECT DEFS.*,
description
FROM (SELECT
(SELECT proname FROM pg_proc WHERE proname IN ('pg_get_viewdef',
'pg_get_viewdef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_viewdef,
(SELECT proname FROM pg_proc WHERE proname IN ('pg_get_ruledef',
'pg_get_ruledef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_ruledef,
(SELECT proname FROM pg_proc WHERE proname IN ('pg_get_expr',
'pg_get_expr2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS
get_expr,
'nix' as get_ruledef, 'expr' as get_expr
) AS DEFS
LEFT OUTER JOIN pg_description ON objoid=132878::oid
2003-06-16 13:21:16 QUERY : Set query (test: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
ORDER BY st.typname, tt.typname
2003-06-16 13:21:16 QUERY : Set query (test: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-06-16 13:21:16 QUERY : Set query (test:5432): SELECT CASE WHEN
nsp.oid<100 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
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE nsp.oid >= 100
AND nsp.nspname NOT LIKE 'pg\_temp\_%'
ORDER BY 1, nspname
2003-06-16 13:21:16 STATUS : Retrieving Database details... Done. (0.28
secs)
2003-06-16 13:21:16 STATUS : Retrieving Schemas details...
2003-06-16 13:21:16 STATUS : Retrieving Schemas details... Done. (0.00
secs)
2003-06-16 13:21:16 STATUS : Retrieving Schema details...
2003-06-16 13:21:16 QUERY : Set query (test: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 = 132946::oid
ORDER BY aggname
2003-06-16 13:21:16 QUERY : Set query (test: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 = 132946::oid
ORDER BY conname
2003-06-16 13:21:16 QUERY : Set query (test: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 = 132946::oid
ORDER BY d.typname
2003-06-16 13:21:16 QUERY : Set query (test: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 = 132946::oid
AND typname <> 'trigger'
ORDER BY proname
2003-06-16 13:21:16 QUERY : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:16 QUERY : Set query (test: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 = 132946::oid
AND typname = 'trigger'
ORDER BY proname
2003-06-16 13:21:16 QUERY : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:16 QUERY : Set query (test: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,
po.proname as operproc, pj.proname as joinproc, pr.proname as
restrproc, description
FROM pg_operator op
JOIN pg_type lt ON lt.oid=op.oprleft
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
JOIN pg_proc po ON po.oid=op.oprcode
LEFT OUTER JOIN pg_
2003-06-16 13:21:16 QUERY : Set query (test:5432): SELECT op.oid, op.*,

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 = 132946::oid
ORDER BY opcname
2003-06-16 13:21:16 QUERY : Set query (test: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 = 132946::oid
ORDER BY relname
2003-06-16 13:21:16 QUERY : Set query (test: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 =
132946::oid
ORDER BY relname
2003-06-16 13:21:16 QUERY : Set query (test: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 = 132946::oid
AND ct.oid IS NULL
ORDER BY t.typname
2003-06-16 13:21:16 QUERY : Set query (test: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
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 = 132946::oid
ORDER BY relname
2003-06-16 13:21:16 STATUS : Retrieving Schema details... Done. (0.32
secs)
2003-06-16 13:21:16 STATUS : Retrieving Schema details...
2003-06-16 13:21:16 STATUS : Retrieving Schema details... Done. (0.00
secs)
2003-06-16 13:21:25 QUERY : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='r' ORDER BY
lower(a.relname)
2003-06-16 13:21:25 QUERY : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='v' ORDER BY
lower(a.relname)
2003-06-16 13:21:46 INFO : Destroying an options dialogue
2003-06-16 13:21:49 STATUS : Retrieving server properties...
2003-06-16 13:21:49 INFO : Displaying properties for Server test:5432
2003-06-16 13:21:49 INFO : Displaying properties for server test:5432
2003-06-16 13:21:49 STATUS : Retrieving server properties... Done. (0.00

secs)
2003-06-16 13:21:50 INFO : Attempting to create a connection object...
2003-06-16 13:21:50 INFO : Creating a connect dialogue
2003-06-16 13:21:52 INFO : Destroying a connect dialogue
2003-06-16 13:21:52 STATUS : Connecting to database without password...
2003-06-16 13:21:52 INFO : Creating pgConn object
2003-06-16 13:21:52 INFO : Server name: test (resolved to: 10.0.0.224)
2003-06-16 13:21:52 INFO : Opening connection with connection string:
hostaddr=10.0.0.224 dbname=template1 user=postgres port=5432
2003-06-16 13:21:52 INFO : Setting client_encoding to 'UNICODE'
2003-06-16 13:21:52 STATUS : Connecting to database without password...
Done. (0.03 secs)
2003-06-16 13:21:52 QUERY : Scalar query (test:5432): SELECT version();
2003-06-16 13:21:52 QUERY : Query result: PostgreSQL 7.3.3 on
i686-pc-linux-gnu, compiled by GCC 2.95.4
2003-06-16 13:21:52 INFO : pgServer object initialised as required.
2003-06-16 13:21:52 INFO : Adding child object to server test:5432
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT db.oid,
datname, datpath, datallowconn, datconfig, datacl,
pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba)

AS datowner
FROM pg_database db
ORDER BY datname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 QUERY : Scalar query (test:5432): SELECT
datlastsysoid FROM pg_database LIMIT 1;
2003-06-16 13:21:52 QUERY : Query result: 16974
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Destroying a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Destroying a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Creating a pgDatabase object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT * from
pg_group
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Creating a pgGroup object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT * FROM
pg_shadow
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Creating a pgUser object
2003-06-16 13:21:52 INFO : Creating a pgUser object
2003-06-16 13:21:52 INFO : Creating a pgUser object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Displaying properties for Databases
Databases
2003-06-16 13:21:52 STATUS : Retrieving Databases details...
2003-06-16 13:21:52 STATUS : Retrieving Databases details... Done. (0.00

secs)
2003-06-16 13:21:52 INFO : Displaying properties for Database mgvd
2003-06-16 13:21:52 STATUS : Retrieving Database details...
2003-06-16 13:21:52 INFO : Creating pgConn object
2003-06-16 13:21:52 INFO : Server name: test (resolved to: 10.0.0.224)
2003-06-16 13:21:52 INFO : Opening connection with connection string:
hostaddr=10.0.0.224 dbname=mgvd user=postgres port=5432
2003-06-16 13:21:52 INFO : Setting client_encoding to 'UNICODE'
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT DEFS.*,
description
FROM (SELECT
(SELECT proname FROM pg_proc WHERE proname IN ('pg_get_viewdef',
'pg_get_viewdef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_viewdef,
(SELECT proname FROM pg_proc WHERE proname IN ('pg_get_ruledef',
'pg_get_ruledef2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS

get_ruledef,
(SELECT proname FROM pg_proc WHERE proname IN ('pg_get_expr',
'pg_get_expr2') AND pronamespace=11 ORDER BY proname DESC LIMIT 1) AS
get_expr,
'nix' as get_ruledef, 'expr' as get_expr
) AS DEFS
LEFT OUTER JOIN pg_description ON objoid=132878::oid
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Adding child object to database mgvd
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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
ORDER BY st.typname, tt.typname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT CASE WHEN
nsp.oid<100 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
FROM pg_namespace nsp
LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
WHERE nsp.oid >= 100
AND nsp.nspname NOT LIKE 'pg\_temp\_%'
ORDER BY 1, nspname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Creating a pgSchema object
2003-06-16 13:21:52 INFO : Creating a pgSchema object
2003-06-16 13:21:52 INFO : Creating a pgSchema object
2003-06-16 13:21:52 INFO : Creating a pgSchema object
2003-06-16 13:21:52 INFO : Creating a pgSchema object
2003-06-16 13:21:52 INFO : Creating a pgSchema object
2003-06-16 13:21:52 INFO : Creating a pgSchema object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 STATUS : Retrieving Database details... Done. (0.24
secs)
2003-06-16 13:21:52 INFO : Displaying properties for Schemas Schemas
2003-06-16 13:21:52 STATUS : Retrieving Schemas details...
2003-06-16 13:21:52 STATUS : Retrieving Schemas details... Done. (0.00
secs)
2003-06-16 13:21:52 INFO : Displaying properties for Schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details...
2003-06-16 13:21:52 INFO : Adding child object to schema security
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 = 132946::oid
ORDER BY aggname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 = 132946::oid
ORDER BY conname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 = 132946::oid
ORDER BY d.typname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 = 132946::oid
AND typname <> 'trigger'
ORDER BY proname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 = 132946::oid
AND typname = 'trigger'
ORDER BY proname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT oid, typname
FROM pg_type
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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,
po.proname as operproc, pj.proname as joinproc, pr.proname as
restrproc, description
FROM pg_operator op
JOIN pg_type lt ON lt.oid=op.oprleft
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
JOIN pg_proc po ON po.oid=op.oprcode
LEFT OUTER JOIN pg_
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test:5432): SELECT op.oid, op.*,

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 = 132946::oid
ORDER BY opcname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 = 132946::oid
ORDER BY relname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Creating a pgSequence object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 =
132946::oid
ORDER BY relname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Creating a pgTable object
2003-06-16 13:21:52 INFO : Creating a pgTable object
2003-06-16 13:21:52 INFO : Creating a pgTable object
2003-06-16 13:21:52 INFO : Creating a pgTable object
2003-06-16 13:21:52 INFO : Creating a pgTable object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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 = 132946::oid
AND ct.oid IS NULL
ORDER BY t.typname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Creating a pgCollection object
2003-06-16 13:21:52 QUERY : Set query (test: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
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 = 132946::oid
ORDER BY relname
2003-06-16 13:21:52 INFO : Creating pgSet object
2003-06-16 13:21:52 INFO : Destroying pgSet object
2003-06-16 13:21:52 INFO : Displaying properties for schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details... Done. (0.33
secs)
2003-06-16 13:21:52 INFO : Displaying properties for Schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details...
2003-06-16 13:21:52 INFO : Displaying properties for schema security
2003-06-16 13:21:52 STATUS : Retrieving Schema details... Done. (0.00
secs)
2003-06-16 13:21:57 INFO : Creating pgConn object
2003-06-16 13:21:57 INFO : Server name: test (resolved to: 10.0.0.224)
2003-06-16 13:21:57 INFO : Opening connection with connection string:
hostaddr=10.0.0.224 dbname=mgvd user=postgres port=5432
2003-06-16 13:21:57 INFO : Setting client_encoding to 'UNICODE'
2003-06-16 13:21:57 INFO : Creating SQL Query box
2003-06-16 13:21:57 INFO : Creating a ctlSQLBox
2003-06-16 13:22:01 INFO : Creating the Query Builder Add Table/View
dialogue
2003-06-16 13:22:01 QUERY : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='r' ORDER BY
lower(a.relname)
2003-06-16 13:22:01 INFO : Creating pgSet object
2003-06-16 13:22:01 INFO : Destroying pgSet object
2003-06-16 13:22:01 QUERY : Set query (test:5432): SELECT a.relname
FROM pg_class a JOIN (SELECT oid,nspname FROM pg_namespace WHERE nspname

<> 'pg_catalog' AND nspname <> 'pg_toast' AND nspname NOT LIKE
'pg_temp_%' ) b ON a.relnamespace = b.oid WHERE a.relkind='v' ORDER BY
lower(a.relname)
2003-06-16 13:22:01 INFO : Creating pgSet object
2003-06-16 13:22:01 INFO : Destroying pgSet object
2003-06-16 13:22:04 INFO : Creating a Query Builder Child Table/View
Frame
---------------END

--
Best regards,

M.