Suspend Referential Integrity?
От | Jim Jarrett |
---|---|
Тема | Suspend Referential Integrity? |
Дата | |
Msg-id | 1123593290.42f8ac4aa10bc@webmail.rpa.net обсуждение исходный текст |
Ответы |
Re: Suspend Referential Integrity?
Re: Suspend Referential Integrity? |
Список | pgsql-novice |
I'm trying to port a database from Oracle to PostgreSQL. I used a perl script, ora2pg to extract the info from Oracle. The table data was extracted in alphabetical order. When I attempt to load it, I get referential integrity violations (eg. I attempt to load CUSTOMER, but CUSTOMOER depends on the SOURCE table, which hasn't been loaded yet). Is there a way to temporarily suspend RI checking so I can load the data and then fix it later? ================================================================= | 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 по дате отправления: