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 <tgl@sss.pgh.pa.us> wrote: "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