Subject | Re: [firebird-support] Re: temporarily disable constraints |
---|---|
Author | Milan Babuskov |
Post date | 2011-09-26T09:56:47Z |
firebirdsql wrote:
alter trigger check_246 INACTIVE
it says:
Triggers created automatically cannot be modified
Looks like you'll have to drop the constraint.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> Firebird uses triggers to enforce check constraints, is it possible to just directly disable the sys triggers instead?I seem to recall doing it with Firebird 1.x, but now when I try:
alter trigger check_246 INACTIVE
it says:
Triggers created automatically cannot be modified
Looks like you'll have to drop the constraint.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================