| From: | Jim Jarrett <jarrett(at)rpa(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Suspend Referential Integrity? |
| Date: | 2005-08-08 13:49:38 |
| Message-ID: | 1123508978.42f762f2e362c@webmail.rpa.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I'm trying to load a database ported from Oracle. The commands I was given to
load data into the table are in alphabetical order; when I run them, I get
errors because I'm violating RI rules (eg. table "CUSTOMER" has RI to "SOURCE",
but CUSTOMER attempts to load before SOURCE).
Certainly, I could try to reorder the load statements, but that would be just a
huge PITA. Is there a way to temporarily suspend RI on a PostgreSQL
database/schema, and then "fix it later?" Either delete the rows that break
rules or add rows to fix the violations?
TIA
=================================================================
| Jim Jarrett,Madison, WI 94 Passat GLX |
| mailto:jarrett(at)rpa(dot)net 81 Rabbit Convertible 16v |
| |
| Any problem can be solved with the proper application of |
| Force, Heat, Chemicals, or Money. |
================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | babu | 2005-08-08 15:04:06 | postgresql with ssl on windows |
| Previous Message | Tom Lane | 2005-08-08 04:25:31 | Re: Tables view? |