Re: identifying duplicate RI triggers

On Fri, 8 Nov 2002, culley harrelson wrote:

> I started looking at the RI triggers in a database that started in 7.0.
> Over time has been migrated to 7.1, 7.2, and 7.2.3 and I think all the
> dumping and reloading has left me with some extra triggers. When do see
> this:
>
> siteadmin=# select tgname, tgargs from pg_trigger where tgname in
> ('RI_ConstraintTrigger_1462942','RI_ConstraintTrigger_1462994');
> tgname |
> tgargs
> ------------------------------+-----------------------------------------------------------------------------------------
> RI_ConstraintTrigger_1462942 |
> <unnamed>\000fe_user\000fe_user_type\000UNSPECIFIED\000user_type_id\000user_type_id\000
> RI_ConstraintTrigger_1462994 |
> <unnamed>\000fe_user\000fe_user_type\000UNSPECIFIED\000user_type_id\000user_type_id\000
> (2 rows)

You can't just use those, you also need to look at least at tgfoid.
There are generally 3 triggers per constraint that IIRC all have
the same args but different function oids.