Re: ALTER TABLE ... NOREWRITE option

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