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?