Re: pgadmin III: query builder

> -----Original Message-----
> From: Marc Cuypers [mailto:mozilla@mgvd.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.