why does a system catalog insert/update/delete not fire a trigger? - Mailing list pgsql-general

From Günther Jedenastik
Subject why does a system catalog insert/update/delete not fire a trigger?
Date
Msg-id 46D6C689.5030600@gmail.com
Whole thread Raw
Responses Re: why does a system catalog insert/update/delete not fire a trigger?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
hiho@ll

As far as i know, the reason a trigger doesn't work on system catalog
(e.g. DDL statements) is because it's not a INSERT SQL statement.
It seems 'simple_heap_insert' is used for insert's.
So i thought why not fire a trigger event after the simple_heap_insert
or the index update's?
What's wrong with fire a trigger event after/before the system catalog
insert/update/delete?
Is it impossible cause it affects data consistency in case the trigger
crashes?

If youre asking yourself why i need this:
i already had some cases where this feature would be helpful.
It's just a nice-to-have and i'm interested in the reasons ;)

thx@ll

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Question regarding autovacuum in 8.1
Next
From: Alvaro Herrera
Date:
Subject: Re: Removing pollution from log files