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 по дате отправления: