"Josh Harrison" <joshques@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
