Re: Triggers and System Tables

Hans-Juergen Schoenig <hs(at)cybertec(dot)at> writes:
> I have a brief question concerning triggers and system tables:
> Why is it not allowed to trigger a system table?

Most of the operations that modify system tables don't bother to fire
triggers ... so if you had a trigger, it would generally fail to capture
the interesting events. I'm not sure what the feasibility would be of
firing triggers everywhere that system tables are updated. Offhand I'd
be worried about whether the system is in a sufficiently self-consistent
state to support trigger execution at all those points.

It would probably also be a *really bad* idea to install a trigger that
tries to alter the row or suppress the update ;-)

regards, tom lane