Suspend Referential Integrity?
От | Jim Jarrett |
---|---|
Тема | Suspend Referential Integrity? |
Дата | |
Msg-id | 1123508978.42f762f2e362c@webmail.rpa.net обсуждение исходный текст |
Ответы |
Re: Suspend Referential Integrity?
|
Список | 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@rpa.net 81 Rabbit Convertible 16v | | | | Any problem can be solved with the proper application of | | Force, Heat, Chemicals, or Money. | ================================================================
В списке pgsql-novice по дате отправления: