Bug when looking for foreign keys

Hello,

I used Ms Visio to reverse engeneer my database and generate
documentation. The problem is that it returns an error when it tries to
get the foreign keys. By generating the log, I found the problem. The
last comma of the FROM statement is absent. My version is the last one
in homepage.

SELECT pt.tgargs, pt.tgnargs,
pt.tgdeferrable, pt.tginitdeferred,
pp1.proname, pp2.proname, pc.oid,
pc1.oid, pc1.relname, pn.nspname FROM
pg_catalog.pg_class pc, pg_catalog.pg_proc
pp1, pg_catalog.pg_proc pp2,
pg_catalog.pg_trigger pt1, pg_catalog.pg_trigger
pt2, pg_catalog.pg_proc pp, pg_catalog.pg_trigger
pt, pg_catalog.pg_class pc1,
pg_catalog.pg_namespace pn pg_catalog.pg_namespace pn1
WHERE pt.tgrelid = pc.oid AND pp.oid = pt.tgfoid AND
pt1.tgconstrrelid = pc.oid AND pp1.oid = pt1.tgfoid AND pt2.tgfoid =
pp2.oid AND pt2.tgconstrrelid = pc.oid AND
((pc.relname='CamposConfiguracao') AND (pn1.oid = pc.relnamespace) AND
(pn1.nspname = 'public') AND (pp.proname LIKE '%ins') AND (pp1.proname
LIKE '%upd') AND (pp2.proname LIKE '%del') AND
(pt1.tgrelid=pt.tgconstrrelid) AND (pt1.tgconstrname=pt.tgconstrname)
AND (pt2.tgrelid=pt.tgconstrrelid) AND
(pt2.tgconstrname=pt.tgconstrname) AND (pt.tgconstrrelid=pc1.oid) AND
(pc1.relnamespace=pn.oid))

Fixed become:

SELECT pt.tgargs, pt.tgnargs,
pt.tgdeferrable, pt.tginitdeferred,
pp1.proname, pp2.proname, pc.oid,
pc1.oid, pc1.relname, pn.nspname FROM
pg_catalog.pg_class pc, pg_catalog.pg_proc
pp1, pg_catalog.pg_proc pp2,
pg_catalog.pg_trigger pt1, pg_catalog.pg_trigger
pt2, pg_catalog.pg_proc pp, pg_catalog.pg_trigger
pt, pg_catalog.pg_class pc1,
pg_catalog.pg_namespace pn , pg_catalog.pg_namespace pn1
WHERE pt.tgrelid = pc.oid AND pp.oid = pt.tgfoid AND
pt1.tgconstrrelid = pc.oid AND pp1.oid = pt1.tgfoid AND pt2.tgfoid =
pp2.oid AND pt2.tgconstrrelid = pc.oid AND
((pc.relname='CamposConfiguracao') AND (pn1.oid = pc.relnamespace) AND
(pn1.nspname = 'public') AND (pp.proname LIKE '%ins') AND (pp1.proname
LIKE '%upd') AND (pp2.proname LIKE '%del') AND
(pt1.tgrelid=pt.tgconstrrelid) AND (pt1.tgconstrname=pt.tgconstrname)
AND (pt2.tgrelid=pt.tgconstrrelid) AND
(pt2.tgconstrname=pt.tgconstrname) AND (pt.tgconstrrelid=pc1.oid) AND
(pc1.relnamespace=pn.oid))

-- Luiz Angelo Daros de Luca Federal University of Santa Catarina
Florianopolis - SC - Brazil luizd(at)inf(dot)ufsc(dot)br ICQ : 19290419 I Know,
"Where you wanted to go today", but I decided to stop here instead! MS
Windows