To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116801





------- Additional comments from [email protected] Sat Feb  5 18:05:20 
+0000 2011 -------
The SDBC driver successfully queries for the structure of the database - here is
the application log

****

Fri Feb  4 10:53:37 2011 [SQL]: executed query 'SELECT DISTINCT ON (pg_namespace
.nspname, relname ) pg_namespace.nspname, relname, relkind, pg_description.descr
iption FROM pg_namespace, pg_class LEFT JOIN pg_description ON pg_class.oid = pg
_description.objoid WHERE relnamespace = pg_namespace.oid AND ( relkind = 'r' OR
 relkind = 'v') AND pg_namespace.nspname LIKE '%' AND relname LIKE 'FILEDOCUMENT
S' ' sucessfully, duration=4ms, returnedRows=1.
Fri Feb  4 10:53:37 2011 [SQL]: executed query 'SELECT DISTINCT ON (pg_namespace
.nspname, relname ) pg_namespace.nspname, relname, relkind, pg_description.descr
iption FROM pg_namespace, pg_class LEFT JOIN pg_description ON pg_class.oid = pg
_description.objoid WHERE relnamespace = pg_namespace.oid AND ( relkind = 'r' OR
 relkind = 'v') AND pg_namespace.nspname LIKE '%' AND relname LIKE 'FILEDOCUMENT
S' ' sucessfully, duration=6ms, returnedRows=1.
Fri Feb  4 10:53:37 2011 [SQL]: executed query 'SELECT attname,attnum FROM pg_at
tribute INNER JOIN pg_class ON attrelid = pg_class.oid INNER JOIN pg_namespace O
N pg_class.relnamespace = pg_namespace.oid WHERE relname='FILEDOCUMENTS' AND nsp
name='public'' sucessfully, duration=4ms, returnedRows=16.
Fri Feb  4 10:53:37 2011 [SQL]: executed query 'SELECT  conname, contype, confup
dtype, confdeltype, class2.relname, nmsp2.nspname, conkey,confkey FROM pg_constr
aint INNER JOIN pg_class ON conrelid = pg_class.oid INNER JOIN pg_namespace ON p
g_class.relnamespace = pg_namespace.oid LEFT JOIN pg_class AS class2 ON confreli
d = class2.oid LEFT JOIN pg_namespace AS nmsp2 ON class2.relnamespace=nmsp2.oid 
WHERE pg_class.relname = 'FILEDOCUMENTS' AND pg_namespace.nspname = 'public'' su
cessfully, duration=10ms, returnedRows=1.
Fri Feb  4 10:53:37 2011 [SQL]: executed query 'SELECT pg_namespace.nspname, pg_
class.relname, pg_attribute.attname, pg_type.typname, pg_attribute.atttypmod, pg
_attribute.attnotnull, pg_type.typdefault, pg_attribute.attnum, pg_type.typtype,
pg_attrdef.adsrc, pg_description.description, pg_type.typbasetype FROM pg_class,
pg_attribute LEFT JOIN pg_attrdef ON pg_attribute.attrelid = pg_attrdef.adrelid
AND pg_attribute.attnum = pg_attrdef.adnum LEFT JOIN pg_description ON
pg_attribute.attrelid = pg_description.objoid AND
pg_attribute.attnum=pg_description.objsubid, pg_type, pg_namespace WHERE
pg_attribute.attrelid = pg_class.oid AND pg_attribute.atttypid = pg_type.oid AND
pg_class.relnamespace = pg_namespace.oid AND pg_namespace.nspname LIKE 'public'
AND pg_class.relname LIKE 'FILEDOCUMENTS' AND pg_attribute.attname LIKE '%'
ORDER BY pg_namespace.nspname || pg_class.relname || pg_attribute.attnum'
sucessfully, duration=15ms, returnedRows=16.

****


---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to