By the looks of it this is Andreas' new dependency code causing this - in particular, the following query:
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
Stop!!!!
This is not the code for dependency! This is the "old constraint trigger" detector code, which shows non-converted (pre-7.3) constraint triggers.
I added this as a response to "where are my triggers, pgadmin2 showed them all right" claims.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
