Firebird uses triggers to enforce check constraints, is it possible to just directly disable the sys triggers instead?
--- In [email protected], Mark Rotteveel <mark@...> wrote: > > On Fri, 23 Sep 2011 04:31:39 -0000, "firebirdsql" <firebirdsql@...> > wrote: > > I'm doing an import of 100k rows into the table which has check > > constraints that do subqueries. > > > > Is there anyway to temporarily disable these constraints? > > Replace the check constraint with a trigger, and disable the trigger when > you are doing the import. > > Mark >
