On 5 December 2012 22:21, Dimitri Fontaine <dimitri@2ndquadrant.fr> wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
>>> CREATE EVENT TRIGGER my_event_trigger
>>> ON table_rewrite
>>> EXECUTE PROCEDURE consider_whether_to_throw_an_error();
>>
>> +1, I was just thinking that myself.
>
> +1, and I think that can happen for 9.3, as soon as we agree on the list
> of code points where we want that event to fire. ALTER TABLE variants
> that are rewriting the heap, sure. CLUSTER? VACUUM FULL? TRUNCATE?
Events needed
* Table rewrite
* Index rebuild
* Relation scan (index/table/toast etc)
* AccessExclusiveLock
-- Simon Riggs http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services