Subject | Re: [firebird-support] Disable / Enable Triggers |
---|---|
Author | t.s. |
Post date | 2006-08-21T06:15:36Z |
> alter trigger blah inactive;Thank you. This might be workable, although it involves maintaining two
> alter trigger blah active;
sets of update scripts. I'm just afraid i'm gonna miss one or two later on.
Hm...
Maybe i can query the system tables to get the names of existing
triggers and write a small program to generate this two sets of scripts
automatically....
> Provided you're doing step 4 with a script or an empty DB, this looksYes. It's a bunch of batch-file driven build scripts ran via isql.
> pretty good.
Thank you,
t.s.