Subject | Re: temporarily disable constraints |
---|---|
Author | firebirdsql |
Post date | 2011-09-23T13:32:28Z |
Firebird uses triggers to enforce check constraints, is it possible to just directly disable the sys triggers instead?
--- In firebird-support@yahoogroups.com, 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
>