Jonathan Hedstrom <jhedstrom@desc.org> writes:
> Does anyone know if it is possible to use system catalogs in foreign key
> constraints in Postgres 7.4.1?
It's not. The system wouldn't enforce the constraint even if you
overrode the permission check, because internal backend catalog updates
don't fire triggers.
regards, tom lane