"Josh Harrison" <[EMAIL PROTECTED]> 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
