Feature Request - Support activation/deactivation of triggers

[GoogleCodeExporter]

In some cases (replication for example) triggers should be temporary 
deactivated and after processing data they should be activated again.

I suppose to add special command:
ALTER TRIGGER trigger_name [ACTIVATE|DEACTIVATE]
or may be shorter syntax
ALTER TRIGGER trigger_name [ON|OFF]

or may be another syntax that would be appropriate.

Original issue reported on code.google.com by kua...@gmail.com on 3 Oct 2009 at 10:11

[GoogleCodeExporter]

Do you know other database(s) that support this feature? If yes could you 
provide
links? I like to keep it compatible.

Moved to the roadmap.

Original comment by thomas.t...@gmail.com on 7 Oct 2009 at 7:02

• Changed state: InRoadmap

[GoogleCodeExporter]

Firebird.

look here: http://www.destructor.de/firebird/trigger.htm

Original comment by kua...@gmail.com on 8 Oct 2009 at 3:57