RI and restoring dumps
От | Robert B. Easter |
---|---|
Тема | RI and restoring dumps |
Дата | |
Msg-id | 00121317043321.00289@comptechnews обсуждение исходный текст |
Ответы |
Re: RI and restoring dumps
Re: RI and restoring dumps |
Список | pgsql-general |
Has anyone experienced referential integrity (RI) problems while restoring data from a dump? Like, if the dump doesn't restore the data in the right order, then primary keys might not be in place before the foreign keys are restored. I want to know this from people who have experience before I do use RI! Actually I did use RI in a database but had complications with it (I forget exactly what it was, something like the order of PL/SQL procedures and RI triggers firing caused some problems) but removed them all and just tried implementing all the checks I wanted in my PL/SQL triggers myself. -- -------- Robert B. Easter reaster@comptechnews.com --------- - CompTechNews Message Board http://www.comptechnews.com/ - - CompTechServ Tech Services http://www.comptechserv.com/ - ---------- http://www.comptechnews.com/~reaster/ ------------
В списке pgsql-general по дате отправления: