Page 1 of 1

wrrong with ZSQLMetadata?????

Posted: 16.10.2006, 08:55
by hitman
i use ZSQLMetadata +postgresql+ mdTables

when acitve but there is nothing i see SQLMonitor
got " SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM,
c.relname AS TABLE_NAME, CASE (n.nspname LIKE 'pg_%')
OR (n.nspname='information_schema') WHEN true THEN CASE n.nspname
WHEN 'pg_catalog' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE'
WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX'
ELSE NULL END WHEN 'information_schema' THEN CASE c.relkind
WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW'
WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN 'pg_toast'
THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE'
WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END
ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE'
WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END
END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE'
WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE'
WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL
END AS TABLE_TYPE, d.description AS REMARKS
FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)
LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')
LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')
WHERE c.relnamespace = n.oid AND n.nspname LIKE '%'
AND c.relname LIKE '%'
AND (false )
ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME " when
i change source " AND (false ) " there is ok