Suspend Referential Integrity?

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. |
================================================================

Responses

Browse pgsql-novice by date

  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?