Subject Re: [firebird-support] temporarily disable constraints
Author Mark Rotteveel
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