Re: dump/restore with a hidden dependency?

On 08/07/2014 01:09 PM, Chris Curvey wrote:

> The "disable trigger" statement runs without error, but does not seem
> to have any effect.

:(

Apparently this trick only works for disabling foreign keys. I'm not
sure how to temporarily disable check constraints. You might have to
drop the constraints after initializing the schemas and re-add them at
the end after the data import is complete.

--
Shaun Thomas
OptionsHouse, LLC | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email