maria-developers team mailing list archive
Mailing list archive
Re: MDEV-7286 TRIGGER: CREATE OR REPLACE, CREATE IF NOT EXISTS
As regards TRIGGERS in MySQL I am very much missing what PostgreSQL (and
maybe other RDBMS as well) has: an option to [temporarily] disable
TRIGGGER[S] for all or specific users - like listed in PostgreSQL docs: (
DISABLE TRIGGER [ trigger_name | ALL | USER ]
ENABLE TRIGGER [ trigger_name | ALL | USER ]
A TRIGGER may work fine with the application it was designed to be used
with. But you may need to do some manual maintenance and then it is not
always desirable that TRIGGERS will fire. It can actually start a chain of
unwanted changes that can be very dificult to correct (unless you resort to
the brutal solution of taking the database offline, dropping TRIGGERS, do
the maintenance and recreate the TRIGGERS).
(unrelated to the code review requested, of course).
On Mon, Feb 9, 2015 at 1:44 PM, Alexander Barkov <bar@xxxxxxxxxxx> wrote:
> Hi Serg,
> Please review a patch for MDEV-7286.
> Mailing list: https://launchpad.net/~maria-developers
> Post to : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help : https://help.launchpad.net/ListHelp