why does a system catalog insert/update/delete not fire a trigger?

Started by none noneover 18 years ago2 messagesgeneral
Jump to latest
#1none none
g.jedenastik@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: none none (#1)
Re: why does a system catalog insert/update/delete not fire a trigger?

=?ISO-8859-15?Q?G=FCnther_Jedenastik?= <g.jedenastik@gmail.com> writes:

What's wrong with fire a trigger event after/before the system catalog
insert/update/delete?

This has been discussed before, see the archives.

regards, tom lane