Subject Re: [firebird-support] Disable trigger?
Author Paul Vinkenoog
Ann Harrison wrote:

> >  execute statement 'alter trigger MyTrigger inactive';
> >  ...
> >  execute statement 'alter trigger MyTrigger active';
> >
> > You need EXECUTE STATEMENT to circumvent the no-DDL rule in PSQL.
> >
> Paul's answer is technically correct, but practically disastrous. Setting
> a trigger to be inactive is a system-wide event and will stop other transactions
> on other connections from logging their changes.

You're completely right.

Paul Vinkenoog