2005-05-17 09:47:59 INFO : Destroying an options dialogue 2005-05-17 09:48:14 INFO : Displaying properties for Table tbldetaillevel_report 2005-05-17 09:48:14 STATUS : Retrieving Table details... 2005-05-17 09:48:14 INFO : Adding child object to table tbldetaillevel_report 2005-05-17 09:48:14 INFO : Creating a pgCollection object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): SELECT att.*, def.*, CASE WHEN attndims > 0 THEN 1 ELSE 0 END AS isarray, CASE WHEN ty.typname = 'bpchar' THEN 'char' WHEN ty.typname = '_bpchar' THEN '_char' ELSE ty.typname END 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_ 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Creating a pgColumn object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 INFO : Creating a pgCollection object 2005-05-17 09:48:14 INFO : Creating a pgConstraint object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname, indnatts, 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 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=con.oid LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0) WHERE indrelid = 7058200::oid AND contype='p' ORDER BY cls.relname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): 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 = 7058200::oid ORDER BY conname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname, indnatts, 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 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=con.oid LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0) WHERE indrelid = 7058200::oid AND contype='u' ORDER BY cls.relname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): 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 = 7058200::oid ORDER BY conname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 INFO : Creating a pgCollection object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname, indnatts, 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 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=con.oid LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0) WHERE indrelid = 7058200::oid AND conname IS NULL ORDER BY cls.relname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Creating a pgIndex object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 INFO : Creating a pgCollection object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): 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 = 7058200 ORDER BY rulename 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 INFO : Creating a pgCollection object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): 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 = 7058200::oid ORDER BY tgname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): 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 = 7058200::oid ORDER BY inhseqno 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 STATUS : Retrieving Table details... (0.40 secs) 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname, indnatts, 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 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=con.oid LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0) WHERE indrelid = 7058200::oid AND contype='p' ORDER BY cls.relname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): 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 = 7058200::oid ORDER BY conname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): SELECT DISTINCT ON(cls.relname) cls.oid, cls.relname as idxname, indrelid, indkey, indisclustered, indisunique, indisprimary, n.nspname, indnatts, 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 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=con.oid LEFT OUTER JOIN pg_description desp ON (desp.objoid=con.oid AND desp.objsubid = 0) WHERE indrelid = 7058200::oid AND contype='u' ORDER BY cls.relname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object 2005-05-17 09:48:14 QUERY : Set query (11.16.152.62:9999): 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 = 7058200::oid ORDER BY conname 2005-05-17 09:48:14 INFO : Creating pgSetBase object 2005-05-17 09:48:14 INFO : Destroying pgSetBase object