| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Chris Curvey <ccurvey(at)zuckergoldberg(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: dump/restore with a hidden dependency? |
| Date: | 2014-08-07 18:37:12 |
| Message-ID: | 53E3C758.90802@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-08-07 18:49:35 | Re: dump/restore with a hidden dependency? |
| Previous Message | Chris Curvey | 2014-08-07 18:09:02 | Re: dump/restore with a hidden dependency? |