From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: ALTER TABLE ... NOREWRITE option |
Date: | 2012-12-05 20:37:52 |
Message-ID: | CA+U5nMJ3uD_kK=zAM=TysggOQ2L=31__HKsFUqvAoyO4-uj=rg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 5 December 2012 19:15, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Dec 5, 2012 at 1:41 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> That's why we need a mechanism which either logs, or aborts on specific
>> actions. From the perspective of the DevOps staff, abort is possibly
>> the better option, but there may be issues with it on our end. That was
>> the attraction of the original NOREWRITE patch, although as I said that
>> suffers from new keywords and a total lack of extensibility.
>
> You know, event triggers seem like an awfully good solution to this
> problem. All we'd need is a new event called table_rewrite:
>
> CREATE EVENT TRIGGER my_event_trigger
> ON table_rewrite
> EXECUTE PROCEDURE consider_whether_to_throw_an_error();
+1, I was just thinking that myself.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2012-12-05 20:41:36 | Re: Dumping an Extension's Script |
Previous Message | Andres Freund | 2012-12-05 20:36:31 | Re: Dumping an Extension's Script |