Thanks Tom. I tried it using pg_class.oid and I still have some records which r not in the pg_class files. What can I do about that? (BTW what does relfilenode in pg_class stands for?) Thanks again Josh
"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.