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: | Raw Message | Whole Thread | 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? |