2003-12-29 15:16:18 STATUS : Retrieving server properties...
2003-12-29 15:16:18 INFO   : Displaying properties for Server delphi:5432
2003-12-29 15:16:18 INFO   : Displaying properties for server delphi:5432
2003-12-29 15:16:18 STATUS : Retrieving server properties... (0.00 secs)
2003-12-29 15:16:20 INFO   : Attempting to create a connection object...
2003-12-29 15:16:20 INFO   : Creating a connect dialogue
2003-12-29 15:16:24 INFO   : Destroying a connect dialogue
2003-12-29 15:16:24 STATUS : Connecting to database...
2003-12-29 15:16:24 INFO   : Creating pgConn object
2003-12-29 15:16:24 INFO   : Server name: delphi (resolved to: 141.142.2.136)
2003-12-29 15:16:24 INFO   : Opening connection with connection string: hostaddr='141.142.2.136' dbname='template1' user='tgam' password='tgamPW' port=5432
2003-12-29 15:16:25 QUERY  : Set query (delphi:5432): SELECT pg_encoding_to_char(encoding) AS encoding, datlastsysoid
  FROM pg_database WHERE datname='template1'
2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Setting client_encoding to 'SQL_ASCII'
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 STATUS : Connecting to database... (0.28 secs)
2003-12-29 15:16:25 QUERY  : Scalar query (delphi:5432): SELECT version();
2003-12-29 15:16:25 QUERY  : Query result: PostgreSQL 7.3.2 on sparc-sun-solaris2.8, compiled by GCC 2.95.2
2003-12-29 15:16:25 QUERY  : Set query (delphi:5432): SELECT usecreatedb, usesuper from pg_user where usename=current_user
2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 STATUS : Restoring previous environment...
2003-12-29 15:16:25 INFO   : pgServer object initialised as required.
2003-12-29 15:16:25 INFO   : Adding child object to server delphi:5432
2003-12-29 15:16:25 INFO   : Creating a pgCollection object
2003-12-29 15:16:25 QUERY  : Set query (delphi: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-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgDatabase object
2003-12-29 15:16:25 INFO   : Creating a pgDatabase object
2003-12-29 15:16:25 INFO   : Creating a pgDatabase object
2003-12-29 15:16:25 INFO   : Destroying a pgDatabase object
2003-12-29 15:16:25 INFO   : Creating a pgDatabase object
2003-12-29 15:16:25 INFO   : Destroying a pgDatabase object
2003-12-29 15:16:25 INFO   : Creating a pgDatabase object
2003-12-29 15:16:25 INFO   : Creating a pgDatabase object
2003-12-29 15:16:25 INFO   : Creating a pgDatabase object
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgCollection object
2003-12-29 15:16:25 QUERY  : Set query (delphi:5432): SELECT * from pg_group ORDER BY groname
2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgCollection object
2003-12-29 15:16:25 QUERY  : Scalar query (delphi:5432): SELECT has_table_privilege('pg_shadow', 'SELECT')
2003-12-29 15:16:25 QUERY  : Query result: f
2003-12-29 15:16:25 QUERY  : Set query (delphi:5432): SELECT * FROM pg_user ORDER BY usename
2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgUser object
2003-12-29 15:16:25 INFO   : Creating a pgUser object
2003-12-29 15:16:25 INFO   : Creating a pgUser object
2003-12-29 15:16:25 INFO   : Creating a pgUser object
2003-12-29 15:16:25 INFO   : Creating a pgUser object
2003-12-29 15:16:25 INFO   : Creating a pgUser object
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 INFO   : Displaying properties for Databases Databases
2003-12-29 15:16:25 INFO   : Displaying properties for Database tgcdb_test
2003-12-29 15:16:25 INFO   : Creating pgConn object
2003-12-29 15:16:25 INFO   : Server name: delphi (resolved to: 141.142.2.136)
2003-12-29 15:16:25 INFO   : Opening connection with connection string: hostaddr='141.142.2.136' dbname='tgcdb_test' user='tgam' password='tgamPW' port=5432
2003-12-29 15:16:25 QUERY  : Set query (delphi:5432): SELECT pg_encoding_to_char(encoding) AS encoding, datlastsysoid
  FROM pg_database WHERE datname='tgcdb_test'
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Setting client_encoding to 'UNICODE'
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 QUERY  : Scalar query (delphi:5432): SELECT description FROM pg_description WHERE objoid=116253::oid
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 INFO   : Query returned no tuples
2003-12-29 15:16:25 QUERY  : Scalar query (delphi:5432): SELECT proname FROM pg_proc WHERE proname='pg_get_viewdef' AND proargtypes[1]=16
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 INFO   : Query returned no tuples
2003-12-29 15:16:25 QUERY  : Scalar query (delphi:5432): SHOW search_path
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 QUERY  : Query result: $user,public
2003-12-29 15:16:25 INFO   : Adding child object to database tgcdb_test
2003-12-29 15:16:25 INFO   : Creating a pgCollection object
2003-12-29 15:16:25 QUERY  : Set query (delphi: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
  LEFT JOIN pg_proc pr ON pr.oid=castfunc
  LEFT JOIN pg_namespace na ON na.oid=pr.pronamespace
 WHERE ca.oid > 16974
 ORDER BY st.typname, tt.typname
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgCollection object
2003-12-29 15:16:25 QUERY  : Set query (delphi: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-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgLanguage object
2003-12-29 15:16:25 INFO   : Creating a pgLanguage object
2003-12-29 15:16:25 INFO   : Creating a pgLanguage object
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgCollection object
2003-12-29 15:16:25 QUERY  : Set query (delphi:5432): SELECT CASE WHEN nspname LIKE 'pg\_temp\_%%' THEN 1
            WHEN nsp.oid<16974 OR nspname like 'pg\_%' THEN 0
            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.nspname NOT LIKE 'pg\_%') ORDER BY 1, nspname
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:25 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:25 INFO   : Creating pgSet object
2003-12-29 15:16:25 INFO   : Creating a pgSchema object
2003-12-29 15:16:25 INFO   : Creating a pgSchema object
2003-12-29 15:16:25 INFO   : Creating a pgSchema object
2003-12-29 15:16:25 INFO   : Destroying pgSet object
2003-12-29 15:16:25 QUERY  : Scalar query (delphi:5432): SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON ns.oid=relnamespace
 WHERE relname='pga_job' AND nspname='pg_admin'
2003-12-29 15:16:25 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:16:26 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:16:26 INFO   : Query returned no tuples
2003-12-29 15:16:26 QUERY  : Scalar query (delphi: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 co.oid IS NULL
     GROUP BY tgargs
    HAVING count(1) = 3) AS foo
2003-12-29 15:16:26 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:52 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:52 QUERY  : Query result: 0
2003-12-29 15:18:52 INFO   : Displaying properties for Schemas Schemas
2003-12-29 15:18:52 INFO   : Displaying properties for Schema amie
2003-12-29 15:18:52 INFO   : Adding child object to schema amie
2003-12-29 15:18:52 INFO   : Creating a pgCollection object
2003-12-29 15:18:52 QUERY  : Set query (delphi: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 = 371776::oid
 ORDER BY aggname
2003-12-29 15:18:52 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:52 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:52 INFO   : Creating pgSet object
2003-12-29 15:18:52 INFO   : Destroying pgSet object
2003-12-29 15:18:52 INFO   : Creating a pgCollection object
2003-12-29 15:18:52 QUERY  : Set query (delphi: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 = 371776::oid
 ORDER BY conname
2003-12-29 15:18:52 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:52 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:52 INFO   : Creating pgSet object
2003-12-29 15:18:52 INFO   : Destroying pgSet object
2003-12-29 15:18:52 INFO   : Creating a pgCollection object
2003-12-29 15:18:52 QUERY  : Set query (delphi: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 = 371776::oid
 ORDER BY d.typname
2003-12-29 15:18:52 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:52 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:52 INFO   : Creating pgSet object
2003-12-29 15:18:52 INFO   : Destroying pgSet object
2003-12-29 15:18:52 INFO   : Creating a pgCollection object
2003-12-29 15:18:52 QUERY  : Set query (delphi: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 = 371776::oid
   AND typname <> 'trigger'
 ORDER BY proname
2003-12-29 15:18:52 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:53 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:53 INFO   : Creating pgSet object
2003-12-29 15:18:53 QUERY  : Set query (delphi:5432): SELECT t.oid, t.typname, n.nspname FROM pg_type t, pg_namespace n WHERE t.typnamespace = n.oid
2003-12-29 15:18:53 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:53 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:53 INFO   : Creating pgSet object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Creating a pgFunction object
2003-12-29 15:18:53 INFO   : Destroying pgSet object
2003-12-29 15:18:53 INFO   : Destroying pgSet object
2003-12-29 15:18:53 INFO   : Creating a pgCollection object
2003-12-29 15:18:53 QUERY  : Set query (delphi: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 = 371776::oid
   AND typname = 'trigger'
 ORDER BY proname
2003-12-29 15:18:53 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:53 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:53 INFO   : Creating pgSet object
2003-12-29 15:18:53 QUERY  : Set query (delphi:5432): SELECT t.oid, t.typname, n.nspname FROM pg_type t, pg_namespace n WHERE t.typnamespace = n.oid
2003-12-29 15:18:53 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:53 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:53 INFO   : Creating pgSet object
2003-12-29 15:18:53 INFO   : Creating a pgTrigger Function object
2003-12-29 15:18:53 INFO   : Creating a pgTrigger Function object
2003-12-29 15:18:53 INFO   : Creating a pgTrigger Function object
2003-12-29 15:18:53 INFO   : Creating a pgTrigger Function object
2003-12-29 15:18:53 INFO   : Creating a pgTrigger Function object
2003-12-29 15:18:53 INFO   : Creating a pgTrigger Function object
2003-12-29 15:18:53 INFO   : Destroying pgSet object
2003-12-29 15:18:53 INFO   : Destroying pgSet object
2003-12-29 15:18:53 INFO   : Creating a pgCollection object
2003-12-29 15:18:53 QUERY  : Set query (delphi: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 des
2003-12-29 15:18:53 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:53 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:53 INFO   : Creating pgSet object
2003-12-29 15:18:53 INFO   : Destroying pgSet object
2003-12-29 15:18:53 INFO   : Creating a pgCollection object
2003-12-29 15:18:53 QUERY  : Set query (delphi: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 = 371776::oid
 ORDER BY opcname
2003-12-29 15:18:53 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:53 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:53 INFO   : Creating pgSet object
2003-12-29 15:18:53 INFO   : Destroying pgSet object
2003-12-29 15:18:53 INFO   : Creating a pgCollection object
2003-12-29 15:18:53 QUERY  : Set query (delphi: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  = 371776::oid
 ORDER BY relname
2003-12-29 15:18:53 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:54 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:54 INFO   : Creating pgSet object
2003-12-29 15:18:54 INFO   : Creating a pgSequence object
2003-12-29 15:18:54 INFO   : Creating a pgSequence object
2003-12-29 15:18:54 INFO   : Destroying pgSet object
2003-12-29 15:18:54 INFO   : Creating a pgCollection object
2003-12-29 15:18:54 QUERY  : Set query (delphi: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 = 371776::oid
 ORDER BY relname
2003-12-29 15:18:54 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:54 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:54 INFO   : Creating pgSet object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Creating a pgTable object
2003-12-29 15:18:54 INFO   : Destroying pgSet object
2003-12-29 15:18:54 INFO   : Creating a pgCollection object
2003-12-29 15:18:54 QUERY  : Set query (delphi: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 = 371776::oid
   AND ct.oid IS NULL
 ORDER BY t.typname
2003-12-29 15:18:54 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:54 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:54 INFO   : Creating pgSet object
2003-12-29 15:18:54 INFO   : Destroying pgSet object
2003-12-29 15:18:54 INFO   : Creating a pgCollection object
2003-12-29 15:18:54 QUERY  : Set query (delphi: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 = 371776::oid
 ORDER BY relname
2003-12-29 15:18:54 QUERY  : DEBUG:  StartTransactionCommand

2003-12-29 15:18:55 QUERY  : DEBUG:  CommitTransactionCommand

2003-12-29 15:18:55 INFO   : Creating pgSet object
2003-12-29 15:18:55 INFO   : Creating a pgView object
2003-12-29 15:18:55 INFO   : Creating a pgView object
2003-12-29 15:18:55 INFO   : Creating a pgView object
2003-12-29 15:18:55 INFO   : Destroying pgSet object
2003-12-29 15:18:55 INFO   : Displaying properties for schema amie
2003-12-29 15:18:55 INFO   : Displaying properties for Schema amie
2003-12-29 15:18:55 INFO   : Displaying properties for schema amie
2003-12-29 15:18:55 STATUS : Restoring previous environment... (150.66 secs)