(I have reported this problem previously, but just wanted to let you know that it remains with this snapshot)
---
Michael
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)
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
