Re: postgres catalog files problem

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Josh Harrison" <joshques(at)gmail(dot)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
>