Dave Page wrote:
>
>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