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