2006-11-09 09:35:07 INFO   : Setting loglevel to: Errors, Notices, &SQL
2006-11-09 09:35:11 STATUS : Retrieving server properties...
2006-11-09 09:35:11 STATUS : Retrieving server properties... (0,00 secs)
2006-11-09 09:35:12 STATUS : Connecting to database...
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SET DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
  FROM pg_database WHERE datname='helpdesk'
2006-11-09 09:35:12 QUERY  : Scalar query (localhost:5432): SELECT version();
2006-11-09 09:35:12 QUERY  : Query result: PostgreSQL 8.0.8 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT proname, pronargs, proargtypes[0] AS arg0, proargtypes[1] AS arg1, proargtypes[2] AS arg2
  FROM pg_proc
  JOIN pg_namespace n ON n.oid=pronamespace
 WHERE proname IN ('pg_tablespace_size', 'pg_file_read', 'pg_logfile_rotate', 'pg_postmaster_starttime', 'pg_terminate_backend', 'pg_reload_conf')
   AND nspname IN ('pg_catalog', 'public')
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT usecreatedb, usesuper
  FROM pg_user WHERE usename=current_user
2006-11-09 09:35:12 STATUS : Connecting to database... (0,14 secs)
2006-11-09 09:35:12 STATUS : Restoring previous environment...
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT db.oid, datname, spcname, 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
  LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
 ORDER BY datname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT ts.oid, spcname, spclocation, pg_get_userbyid(spcowner) as spcuser, spcacl FROM pg_tablespace ts
 ORDER BY spcname
2006-11-09 09:35:12 QUERY  : Scalar query (localhost:5432): SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace
 WHERE relname='pga_job' AND nspname='pgagent'
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT * from pg_group ORDER BY groname
2006-11-09 09:35:12 QUERY  : Scalar query (localhost:5432): SELECT has_table_privilege('pg_shadow', 'SELECT')
2006-11-09 09:35:12 QUERY  : Query result: f
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT * FROM pg_user ORDER BY usename
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT setting FROM pg_settings
 WHERE name IN ('autovacuum', 'stats_start_collector', 'stats_row_level')
2006-11-09 09:35:12 QUERY  : Scalar query (localhost:5432): SELECT description FROM pg_description WHERE objoid=6205160::oid
2006-11-09 09:35:12 QUERY  : Scalar query (localhost:5432): SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16
2006-11-09 09:35:12 QUERY  : Query result: pg_get_viewdef
2006-11-09 09:35:12 QUERY  : Scalar query (localhost:5432): SHOW search_path
2006-11-09 09:35:12 QUERY  : Query result: $user,public
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT nspname, session_user=nspname AS isuser FROM pg_namespace
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT ca.oid, ca.*, format_type(st.oid,NULL) AS srctyp, format_type(tt.oid,tt.typtypmod) AS trgtyp, ns.nspname AS srcnspname, nt.nspname AS trgnspname,
 proname, np.nspname AS pronspname, description
  FROM pg_cast ca
  JOIN pg_type st ON st.oid=castsource
  JOIN pg_namespace ns ON ns.oid=st.typnamespace
  JOIN pg_type tt ON tt.oid=casttarget
  JOIN pg_namespace nt ON nt.oid=tt.typnamespace
  LEFT JOIN pg_proc pr ON pr.oid=castfunc
  LEFT JOIN pg_namespace np ON np.oid=pr.pronamespace
  LEFT OUTER JOIN pg_description des ON des.objoid=ca.oid AND des.objsubid=0
 ORDER BY st.typname, tt.typname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT lan.oid, lan.lanname, lanpltrusted, lanacl, hp.proname as lanproc, vp.proname as lanval, description
  FROM pg_language lan
  JOIN pg_proc hp on hp.oid=lanplcallfoid
  LEFT OUTER JOIN pg_proc vp on vp.oid=lanvalidator
  LEFT OUTER JOIN pg_description des ON des.objoid=lan.oid AND des.objsubid=0
 WHERE lanispl IS TRUE
 ORDER BY lanname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT CASE WHEN nspname LIKE 'pg\_temp\_%%' THEN 1
            WHEN (nspname LIKE 'pg\_%' OR nspname = 'information_schema') THEN 0
            ELSE 3 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
 ORDER BY 1, nspname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT nsp.oid, substr(nspname, 2) as clustername, nspname, pg_get_userbyid(nspowner) AS namespaceowner, description
  FROM pg_namespace nsp
  LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid
  JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'
 ORDER BY nspname
2006-11-09 09:35:12 QUERY  : Scalar query (localhost:5432): SELECT COUNT(*) FROM
   (SELECT tgargs from pg_trigger tr
      LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i'
      LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f'
     WHERE tgisconstraint AND co.oid IS NULL
     GROUP BY tgargs
    HAVING count(1) = 3) AS foo
2006-11-09 09:35:12 QUERY  : Query result: 0
2006-11-09 09:35:12 QUERY  : Set query (localhost: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
2006-11-09 09:35:12 QUERY  : Set query (localhost: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, description
  FROM pg_conversion co
  JOIN pg_proc pr ON pr.oid=conproc
  JOIN pg_namespace na ON na.oid=pr.pronamespace
  LEFT OUTER JOIN pg_description des ON des.objoid=co.oid AND des.objsubid=0
 WHERE connamespace = 2200::oid
 ORDER BY conname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT d.oid, d.typname as domname, d.typbasetype, format_type(b.oid,NULL) as basetype, pg_get_userbyid(d.typowner) as domainowner, 
       d.typlen, d.typtypmod, d.typnotnull, d.typdefault, d.typndims, d.typdelim, bn.nspname as basensp,
       description, (SELECT COUNT(1) FROM pg_type t2 WHERE t2.typname=d.typname) > 1 AS domisdup,
       (SELECT COUNT(1) FROM pg_type t3 WHERE t3.typname=b.typname) > 1 AS baseisdup
  FROM pg_type d
  JOIN pg_type b ON b.oid = CASE WHEN d.typndims>0 then d.typelem ELSE d.typbasetype END
  JOIN pg_namespace bn ON bn.oid=b.typnamespace
  LEFT OUTER JOIN pg_description des ON des.objoid=d.oid
 WHERE d.typtype = 'd' AND d.typnamespace = 2200::oid
 ORDER BY d.typname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, TYPNS.nspname AS typnsp, lanname, proargnames, pg_get_userbyid(proowner) as funcowner, description
  FROM pg_proc pr
  JOIN pg_type TYP ON TYP.oid=prorettype
  JOIN pg_namespace TYPNS ON TYPNS.oid=TYP.typnamespace
  JOIN pg_language LNG ON LNG.oid=prolang
  LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
 WHERE proisagg = FALSE AND pronamespace = 2200::oid
   AND typname <> 'trigger'
 ORDER BY proname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT t.oid, format_type(t.oid, t.typtypmod) AS typname, n.nspname FROM pg_type t, pg_namespace n WHERE t.typnamespace = n.oid
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, TYPNS.nspname AS typnsp, lanname, proargnames, pg_get_userbyid(proowner) as funcowner, description
  FROM pg_proc pr
  JOIN pg_type TYP ON TYP.oid=prorettype
  JOIN pg_namespace TYPNS ON TYPNS.oid=TYP.typnamespace
  JOIN pg_language LNG ON LNG.oid=prolang
  LEFT OUTER JOIN pg_description des ON des.objoid=pr.oid
 WHERE proisagg = FALSE AND pronamespace = 2200::oid
   AND typname = 'trigger'
 ORDER BY proname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT t.oid, format_type(t.oid, t.typtypmod) AS typname, n.nspname FROM pg_type t, pg_namespace n WHERE t.typnamespace = n.oid
2006-11-09 09:35:12 QUERY  : Set query (localhost: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_description
2006-11-09 09:35:12 QUERY  : Set query (localhost: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
2006-11-09 09:35:12 QUERY  : Set query (localhost: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
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT rel.oid, relname, spcname, pg_get_userbyid(relowner) AS relowner, relacl, relhasoids, relhassubclass, reltuples, description, conname, conkey,
       EXISTS(select 1 FROM pg_trigger
                       JOIN pg_proc pt ON pt.oid=tgfoid AND pt.proname='logtrigger'
                       JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND pc.proname='slonyversion'
                     WHERE tgrelid=rel.oid) AS isrepl
  FROM pg_class rel
  LEFT OUTER JOIN pg_tablespace ta on ta.oid=rel.reltablespace
  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 IN ('r','s','t') AND relnamespace = 2200::oid
 ORDER BY relname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT t.oid, t.*, format_type(t.oid, null) AS alias, pg_get_userbyid(t.typowner) as typeowner, e.typname as element, description, ct.oid AS taboid
  FROM pg_type t
  LEFT OUTER JOIN pg_type e ON e.oid=t.typelem
  LEFT OUTER JOIN pg_class ct ON ct.oid=t.typrelid AND ct.relkind <> 'c'
  LEFT OUTER JOIN pg_description des ON des.objoid=t.oid
 WHERE t.typtype != 'd' AND t.typname NOT LIKE '\\_%%' AND t.typnamespace = 2200::oid
 ORDER BY t.typname
2006-11-09 09:35:12 QUERY  : Set query (localhost:5432): SELECT c.oid, c.xmin, c.relname, pg_get_userbyid(c.relowner) AS viewowner, c.relacl, description, pg_get_viewdef(c.oid, true) AS definition
  FROM pg_class c
  LEFT OUTER JOIN pg_description des ON (des.objoid=c.oid and des.objsubid=0)
 WHERE ((c.relhasrules AND (EXISTS (
           SELECT r.rulename FROM pg_rewrite r
            WHERE ((r.ev_class = c.oid)
              AND (bpchar(r.ev_type) = '1'::bpchar)) ))) OR (c.relkind = 'v'::char))
   AND relnamespace = 2200::oid
 ORDER BY relname
2006-11-09 09:35:13 STATUS : Restoring previous environment... (0,50 secs)
2006-11-09 09:35:23 STATUS : Retrieving Table details...
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT att.*, def.*, CASE WHEN attndims > 0 THEN 1 ELSE 0 END AS isarray, format_type(ty.oid,NULL) AS typname, tn.nspname as typnspname, et.typname as elemtypname,
  cl.relname, na.nspname, att.attstattarget, description, cs.relname AS sername, ns.nspname AS serschema,
  (SELECT count(1) FROM pg_type t2 WHERE t2.typname=ty.typname) > 1 AS isdup, indkey,
  EXISTS(SELECT 1 FROM  pg_constraint WHERE conrelid=att.attrelid AND contype='f' AND att.attnum=ANY(conkey)) As isfk
  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
  LEFT OUTER JOIN (pg_depend JOIN pg_class cs ON objid=cs.oid AND cs.relkind='S') ON refobjid=attrelid AND refobjsubid=a
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname,
       indnatts, spcname, tab.relname as tabname, indclass, CASE contype WHEN 'p' THEN desp.description ELSE des.description END AS description,
       pg_get_expr(indpred, indrelid, true) 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_tablespace ta on ta.oid=cls.reltablespace
  JOIN pg_namespace n ON n.oid=tab.relnamespace
  JOIN pg_am am ON am.oid=cls.relam
  LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid = '0')
  LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid)
  LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
  LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0)
 WHERE i
2006-11-09 09:35:23 QUERY  : Set query (localhost: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 = 6206193::oid
 ORDER BY conname
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname,
       indnatts, spcname, tab.relname as tabname, indclass, CASE contype WHEN 'p' THEN desp.description ELSE des.description END AS description,
       pg_get_expr(indpred, indrelid, true) 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_tablespace ta on ta.oid=cls.reltablespace
  JOIN pg_namespace n ON n.oid=tab.relnamespace
  JOIN pg_am am ON am.oid=cls.relam
  LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid = '0')
  LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid)
  LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
  LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0)
 WHERE i
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT c.oid, conname, condeferrable, condeferred, relname, nspname, description,
       pg_get_expr(conbin, conrelid, true) as consrc
  FROM pg_constraint c
  JOIN pg_class cl ON cl.oid=conrelid
  JOIN pg_namespace nl ON nl.oid=relnamespace
  LEFT OUTER JOIN pg_description des ON des.objoid=c.oid
 WHERE contype = 'c' AND conrelid =  6206193::oid
 ORDER BY conname
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname,
       indnatts, spcname, tab.relname as tabname, indclass, CASE contype WHEN 'p' THEN desp.description ELSE des.description END AS description,
       pg_get_expr(indpred, indrelid, true) 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_tablespace ta on ta.oid=cls.reltablespace
  JOIN pg_namespace n ON n.oid=tab.relnamespace
  JOIN pg_am am ON am.oid=cls.relam
  LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid = cls.oid AND dep.refobjsubid = '0')
  LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid AND con.oid = dep.refobjid)
  LEFT OUTER JOIN pg_description des ON des.objoid=cls.oid
  LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0)
 WHERE i
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT rw.oid, rw.ev_class, rulename, relname, nspname, description, is_instead, ev_type, ev_action, ev_qual,
       pg_get_ruledef(rw.oid, true) 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 = 6206193
 ORDER BY rulename
2006-11-09 09:35:23 QUERY  : Set query (localhost: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 = 6206193::oid
 ORDER BY tgname
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT attname
  FROM pg_attribute
 WHERE attrelid=6206193::oid AND attnum IN (2)
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT attname
  FROM pg_attribute
 WHERE attrelid=6206193::oid AND attnum IN (7)
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT count(*) AS rows FROM ONLY hd_tecnicos
2006-11-09 09:35:23 QUERY  : Set query (localhost: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 = 6206193::oid
 ORDER BY inhseqno
2006-11-09 09:35:23 STATUS : Retrieving Table details... (0,26 secs)
2006-11-09 09:35:23 QUERY  : Scalar query (localhost:5432): SELECT
  CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
    pg_get_indexdef(i.indexrelid, 1, true) || ' ' || o.opcname
  ELSE
    pg_get_indexdef(i.indexrelid, 1, true)
  END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 1)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[0])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY  : Query result: idempresa
2006-11-09 09:35:23 QUERY  : Scalar query (localhost:5432): SELECT
  CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
    pg_get_indexdef(i.indexrelid, 2, true) || ' ' || o.opcname
  ELSE
    pg_get_indexdef(i.indexrelid, 2, true)
  END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 2)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[1])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY  : Query result: idusuario
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT opcname FROM pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT opcname FROM pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY  : Scalar query (localhost:5432): SELECT
  CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
    pg_get_indexdef(i.indexrelid, 1, true) || ' ' || o.opcname
  ELSE
    pg_get_indexdef(i.indexrelid, 1, true)
  END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 1)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[0])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY  : Query result: idempresa
2006-11-09 09:35:23 QUERY  : Scalar query (localhost:5432): SELECT
  CASE WHEN (o.opcdefault = FALSE AND o.opcintype != a.atttypid) THEN
    pg_get_indexdef(i.indexrelid, 2, true) || ' ' || o.opcname
  ELSE
    pg_get_indexdef(i.indexrelid, 2, true)
  END
FROM pg_index i
JOIN pg_attribute a ON (a.attrelid = i.indexrelid AND attnum = 2)
LEFT OUTER JOIN pg_opclass o ON (o.oid = i.indclass[1])
WHERE i.indexrelid = 6209046::oid
2006-11-09 09:35:23 QUERY  : Query result: idusuario
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT opcname FROM pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT opcname FROM pg_opclass WHERE oid=1978
2006-11-09 09:35:23 QUERY  : Set query (localhost:5432): SELECT rw.oid, rw.ev_class, rulename, relname, nspname, description, is_instead, ev_type, ev_action, ev_qual,
       pg_get_ruledef(rw.oid, true) 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 = 6206193
 ORDER BY rulename
2006-11-09 09:35:23 QUERY  : Set query (localhost: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 = 6206193::oid
 ORDER BY tgname
2006-11-09 09:35:40 QUERY  : Set query (localhost:5432): SET DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
  FROM pg_database WHERE oid = 6205160
2006-11-09 09:35:40 QUERY  : Thread Query SELECT * FROM hd_tecnicos ORDER BY idempresa, idusuario ASC
2006-11-09 09:35:40 QUERY  : Set query (localhost:5432): SELECT n.nspname AS nspname, relname, format_type(t.oid,NULL) AS typname, format_type(t.oid, att.atttypmod) AS displaytypname, nt.nspname AS typnspname, attname, attnum, COALESCE(b.oid, t.oid) AS basetype, atthasdef, adsrc,
       CASE WHEN t.typbasetype::oid=0 THEN att.atttypmod else t.typtypmod END AS typmod,
       CASE WHEN t.typbasetype::oid=0 THEN att.attlen else t.typlen END AS typlen
  FROM pg_attribute att
  JOIN pg_type t ON t.oid=att.atttypid
  JOIN pg_namespace nt ON nt.oid=t.typnamespace
  JOIN pg_class c ON c.oid=attrelid
  JOIN pg_namespace n ON n.oid=relnamespace
  LEFT OUTER JOIN pg_type b ON b.oid=t.typbasetype
  LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum
 WHERE attnum > 0 AND NOT attisdropped AND attrelid=6206193::oid
 ORDER BY attnum
2006-11-09 09:35:40 QUERY  : Scalar query (localhost:5432): SELECT format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:40 QUERY  : Query result: integer
2006-11-09 09:35:40 QUERY  : Scalar query (localhost:5432): SELECT format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:40 QUERY  : Query result: integer
2006-11-09 09:35:40 QUERY  : Scalar query (localhost:5432): SELECT format_type(oid,NULL) as typname FROM pg_type WHERE oid = 21
2006-11-09 09:35:41 QUERY  : Query result: smallint
2006-11-09 09:35:41 QUERY  : Scalar query (localhost:5432): SELECT format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:41 QUERY  : Query result: integer
2006-11-09 09:35:41 QUERY  : Scalar query (localhost:5432): SELECT format_type(oid,NULL) as typname FROM pg_type WHERE oid = 23
2006-11-09 09:35:41 QUERY  : Query result: integer
2006-11-09 09:35:51 QUERY  : Set query (localhost:5432): INSERT INTO hd_tecnicos(idempresa, ativo, idusuario, idpessoa) VALUES (6::integer, 1::smallint, 11::integer, 1::integer)
2006-11-09 09:35:51 QUERY  : Scalar query (localhost:5432): SELECT version();
2006-11-09 09:35:51 QUERY  : Query result: PostgreSQL 8.0.8 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)
2006-11-09 09:39:52 STATUS : Retrieving Servers details...
2006-11-09 09:39:52 STATUS : Retrieving Servers details... (0,00 secs)