Re: postgres catalog files problem - Mailing list pgsql-general

"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