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
On 9/17/07, Tom Lane <[EMAIL PROTECTED]> wrote: > > "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 >