"Josh Harrison" <joshques@gmail.com> writes:
> if I give this query, which checks for the triggers that do not have
> corresponding tables in the pg_class
> select * from pg_trigger where tgrelid not in (select relfilenode from
> pg_class),
This query is wrong --- relfilenode is not a join column for any other
table. You should be using pg_class.oid there.
regards, tom lane